Newest image(s) on website

[Draycon]

Hi,
I searched a little on the forum to find an answer, but failed so far.

I am looking for a way to access the latest images from my photopost gallery USA Views - Main Index to include the thumbnails as preview (and link) to the gallery on the frontpage of my php homepage. So the result should be a simple picture (thumbnail).

Greetings
Stefan

[Chuck S]

http://www.photopost.com/forum/photo...-anywhere.html

Maybe something like this.

[Draycon]

Thanks Chuck, that nearly solved my problem All I have to know is how to change the line

$result = mysql_query("SELECT id,cat,bigimage FROM pp_photos order by rand() LIMIT 3" ) or die(mysql_error());

to output the newest 3 images instead of random ones. However, it works so far.

[Chuck S]

order by rand()

Maybe

ORDER BY date DESC;

[Draycon]

Thats it, thanks alot

[Chuck S]

glad to assist have a good one