Problem viewing image blobs

[Philth]

Hi there, I did post yesterday regarding an error I had with this script - which was solved. Unfortunately now the script doesn't actually result in anything! Not even an error.

The script below is supposed to pull the image blob data out of the database depending on the id sent via a html image tag. I know that part works correctly so the problem must be with the script. I'm just not sure where.

First the html code...

[HTML]
<img src='php/image.php?albumNumber=$albumNumber'/>
[/HTML]

Now the php...

[PHP]
<?php
if(isset($_GET['albumNumber']))
{
mysql_connect("","","");
mysql_select_db("");

$albumNumber = $_GET['albumNumber'];
$query = "SELECT content FROM Albums WHERE albumNumber = '$albumNumber'";

$result = mysql_query($query);
$content=$r['content'];

header("Content-Type: image/jpeg");
echo $content;
}
?>
[/PHP]


I'm really stuck on this one - especially with no error!
'content' is the column storing all the image data in the database.

Thanks.

[pbmods]

Heya, Philth.

Where do you call mysql_fetch_assoc() to pull the data from the MySQL result resource?

[Philth]

Thanks for that. I've added this line, so the script reads as follows...

 
<?php
if(isset($_GET['albumNumber'])) 
{
mysql_connect("","",""); 
mysql_select_db("freelance"); 
 
$albumNumber = $_GET['albumNumber'];
$query = "SELECT content FROM Albums WHERE albumNumber = '$albumNumber'";
 
$result = mysql_query($query);
$content = mysql_fetch_row($result);
 
 
header("Content-Type: image/jpeg"); 
echo $content;
} 
?>
 
 

Still does nothing. When the image I'm trying to display is uploaded to the database I'm storing the file name, the file size, the file type and all the garbled data(content). I am correct in trying to retrieve the data in the content field?

[Lumpy]

Your close, but give this a try...

 
<?php
if(isset($_GET['albumNumber'])) 
{
mysql_connect("","",""); 
mysql_select_db("freelance"); 
 
$albumNumber = $_GET['albumNumber'];
$query = "SELECT content FROM Albums WHERE albumNumber = '$albumNumber'";
 
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$content = $row['content'];
 
header("Content-Type: image/jpeg"); 
echo $content;
} 
?>