Downloading from mysql databse

hey pros, i have a problem with my download.php page i have a database with a table that stores pdf files and these files are displayed on the files page and want users to download them

So what problem are you having and what is the relevant code causing the problem???

Yeah...what's the problem here? You list files and you want to make them clickable? Do that, see what happens. Look into readfile() and the header() function to send the appropriate file headers for PDFs (google will help with that)

$fileId = $_GET["fileId"];
$sql = "SELECT File_Type, File_Name, File_Size, File_Bytes FROM exams WHERE File_ID = ?";
$dsn = 'mysql:dbname=fred;host=localhost;port=3306';
$user = 'root';
$password = '';

try {
$dbh = new PDO($dsn, $user, $password);

$stmt = $dbh->prepare($sql) or die (implode(':', $stmt->errorInfo()));
$stmt->bindParam(1, $fileId, PDO::PARAM_INT, 60);
$stmt->execute() or die (implode(':', $stmt->errorInfo()));

$row = $stmt->fetch();
header("Content-type: $row[0]");
header("Content-length: $row[2]");
header("Content-disposition: attachment; filename=$row[1]");
print $row[3];

} catch (PDOException $e) {
die ('Connection failed: '.$e->getMessage());
}
?>

Are you getting an error message? Also wrap code with the php tags.

Just a total guess... Is your SQL statement supposed to end as "WHERE File_ID = ?". It seems your '?' should be replaced with your $fileId value.

try/catch only catches exceptions. PDO doesn't throw an exception when a query fails. You need to handle the errors yourself.