refering to images stored in folder

[Anon]

Hi, pretty simple thing really but i am am rather new to this gig so bear with me please. I am able to upload images to a folder fine (using php4 and mySQL) but i am not sure how to pull thme back out in properly.Can anyone help with with please... Here is the code i am using..

<?php

$db = mysql_connect("localhost","root");
mysql_select_db("antiques",$db) or die(mysql_errno() . ": " . mysql_error() . "<br>");

$sql = "SELECT * FROM general ";
$sql .= "ORDER BY filename ASC";
$result = mysql_query($sql, $db);
$rows = mysql_num_rows($result);

echo "<table border=1>\n";
echo " <tr>\n";
echo " <td>Image</td>\n";
echo " <td>Name</td>\n";
echo " <td>Description</td>\n";
echo " <td>Price</td>\n";
echo " <td> </td>\n";
echo " </tr>\n";

for ($i = 0; $i < $rows; $i++) {
$data = mysql_fetch_object($result);
echo " <td>$data-><img src=image_name></td>\n";
echo " <td>$data->name</td>\n";
echo " <td>$data->description</td>\n";
echo " <td>$data->price</td>\n";
echo " </tr>\n";

}
mysql_free_result($result);
mysql_close($db);
?>

[Anon]

echo " <td>$data-><img src=image_name></td>\n";

That won't work. Did you mean:

echo " <td><img src=$data->image_name></td>\n";
?

If that doesn't solve the problem, you have to tell us what the problem is.

Diego

[Anon]

thanks, replaced that piece of code but its not showing anything apart from

Parse error: parse error in c:\program files\apache group\realdocs\files\antiquesbasic\viewfiles.php on line 24

code...
<?php

$db = mysql_connect("localhost","root");
mysql_select_db("antiques",$db) or die(mysql_errno() . ": " . mysql_error() . "<br>");

$sql = "SELECT * FROM general ";
$sql .= "ORDER BY filename ASC";
$result = mysql_query($sql, $db);
$rows = mysql_num_rows($result);

echo "<table border=1>\n";
echo " <tr>\n";
echo " <td>Image</td>\n";
echo " <td>Name</td>\n";
echo " <td>Description</td>\n";
echo " <td>Price</td>\n";
echo " <td> </td>\n";
echo " </tr>\n";

for ($i = 0; $i < $rows; $i++) {
$data = mysql_fetch_object($result);
echo " <td><img src=$data->image_name></td>\n";</td>\n";
echo " <td>$data->name</td>\n";
echo " <td>$data->description</td>\n";
echo " <td>$data->price</td>\n";
echo " </tr>\n";

}
mysql_free_result($result);
mysql_close($db);
?>

Not sure what the problem is but i'd say it doesnt know where the image is stored (in addition to the parse error.....thanks for any help you can give me