Reading rows in reverse

[stovellp]

Hi, I have a big silly database (MySQL) that stores entries for a news page. The idea is I enter the news into the database and the php page reads them out the database.

I have it running just fine right now, but the problem is it reads them in a loops, and prints them out. Unfortunately it prints the oldest row of the table last, and works its way down, the opposite of what I want it to do. Is there a way I could tell a functions like mysql_fetch_array to fetch the last entry first, and work down?

Any help on this matter would be great,

~ Paul

[cyclops]

I guess you are using a date field somewhere ?

Then to this :

SELECT * FROM yourtable ORDER BY yourdate DESC LIMIT 0,10

ORDER BY yourdate DESC = sort Descending
LIMIT 0,10 = only last 10 rows

if you want to show all rows, leave LIMIT 0,10 out

[stovellp]

Ahhhh, genius! I should look into these query things much more, at this time all I know is SELECT and INSERT, and hardly anyof the options for them. Thank you very much! 🙂

~ Paul