RE: server error or script error

["Flavien CHANTELOT" <fchantelot@xxxxxxxxxxx>]

I guess the problem is here : 
$query = "SELECT * FROM mypdfs WHERE id =$id";
Change it to : 
$query = "SELECT * FROM mypdfs WHERE id =".$id;



-----Message d'origine-----
De : Ross [mailto:ross@xxxxxxxxxxxxx] 
Envoyé : jeudi 8 mars 2007 09:39
À : php-general@xxxxxxxxxxxxx
Objet :  server error or script error

<?php

include ('../phpscripts/connect.php');
$id = $_GET['id'];

$query = "SELECT * FROM mypdfs WHERE id =$id";

$result= mysql_query($query) or die('Error, query failed');

if (!mysql_num_rows($result))
{
   die("No matching records were found in the database.");
}


   while  ($row = mysql_fetch_array($result, MYSQL_ASSOC)){

  $size=$row['pdf_size'];
   $type=$row['pdf_type'];
$name=$row['pdf_name'];
   $content=$row['content'];

header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; $name; ");
echo $content;
}


?>

I use this script but is had sudenly stop working. I think it is a config 
change on the remote server. The porblem is the file either doesn't open or 
downloads as download.php

Can anyone suggest a way to improve this script or debug to fins out if it 
is a script error or server error.


R. 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php