I'm trying to receive data from a mysql database through php.
Using the command line at mysql listed below gives me a result set.
I am able to connect to the database through php, however, when using the
following script, I receive no data when the data is in the table called
pictures in the db called sitename.
<?
if($ID) {
@MYSQL_CONNECT("localhost","root","thepassword");
@mysql_select_db("sitename");
$query = "select bin_data,filetype from pictures where ID=$ID";
$result = @MYSQL_QUERY($query);
$data = @MYSQL_RESULT($result,0,"bin_data");
$type = @MYSQL_RESULT($result,0,"filetype");
Header( "Content-type: $type");
echo $data;
}
?>
// In browser window it reads:
// http://localhost/download.php?filename=7
//...and on the Command Line using the following query:
// SELECT filetype FROM pictures where ID=$ID
// gives me a image/pjpeg as the result set.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
