PHP & MySQL

[Jperensky]

I wrote a guestbook script using PHP and MySQL and want to load the entries from the bottom of the table to the top so the most recent posts would appear at the top of the list. I know I could do this by creating a large array and display the information by counting down, but I was hoping there was some other way; maybe a special funtion or something.

Thank You

[whackaxe]

add this to your mysql query

ORDER BY ID DESC

ID is your generic primary key, auto_increment, not null index column

[Thantos]

Just change your query. I'm assuming you have a date stamp or an entry id for each one.

Look into the ORDER BY part of the SELECT query.