mysql_fetch_row

[Anon]

Ok, I have a simple script set up which fetchs rows from a database and outputs them in a nice formatted fashion.

Now here is my question. How would I make it so that the "fetching" start from the last row of the table and works its way up.

It's a news system, if you are wondering, and when my input script inserts a new row, it adds it to the bottom. When my fetching script "fetches" the data, it starts fromt the top. Not good since I want the order to be from newest to oldest.

Please help ASAP! Thanks!

[Anon]

You could add 'ORDER BY field_name DESC'
where field_name could be an auto_increment row.

Then it orders from the highest id to the lowest. Or use it on a field with a date in

Example:
mysql_query("SELECT id FROM table ORDER BY id DESC");

Hope this helps

/Staffan

[Anon]

Thanks! I got it working. I had to add an auto_increment id column though. No biggie. Should've done that anyway.

Thanks again.