Retrieve and display attachments from database

[matt3830]

I'm trying to retrieve the 10 most recent attachments on an outside page. My attachments are in files. This is what I've come up with so far, but I don't know what the path is to the images and how to display them. Any suggestions?

<?php

$result = mysql_query("SELECT * FROM attachment ORDER BY dateline DESC LIMIT 0,10", $connection);
if (!$result) {
die("Database query failed: " . mysql_error());
}

while ($row = mysql_fetch_array($result)) {
echo "<img src=\"/attachmentpath/" . $row[4] . "/><br />";
}
?>