Retrieve and display attachments from database
 

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 />";
}
?>

The attachment table will define the type of attachment.

The actual attachments live in

baseaddress/attachments/u/s/r/i/d/attachmentid.attach

The user ID is broken into individual digits as directories, so if you have userid 603 and an attachment id of 500 then it will live in

attachments/6/0/3/500.attach

There is also an attendant 500.thumb

Thanks, so I have the path, but how do you display .attach?

".attach" is just a temporary extension. The content of this ".attach" file is the actual file.

Query the attachment table to see what kind of file it actually is, and then convince php to handle the file correctly. This may involve moving the file to /tmp with the appropriate suffix, or...well...something else. php/file system interactions are not my forte.

Basically, you just need to send the correct headers to the browser.