[RESOLVED] Reversing mysql_fetch_array results

[urbley]

Ok I'm just getting back into the swing of things again after not having used php and mysql for quite some time. I'm using a simple while (mysql_fetch_array = $result){ blah blah to echo tables rows containing messages stored in the database. All ok and fine so far.

Is there a simple way to reverse the contents of the database while still using this function? I.e. show the latest post first. I thought about just adding a new field to the table like id and then using an ORDER BY statement in the SQL but before I do this I just wondered if anyone knew of a different way.

Not because I'm lazy but just out of curiosity to be honest.

Thanks,
Steve.

[laserlight]

Doing it in the SQL statement with ORDER BY is the correct way.

If not, you would loop through the result set and store into an array, then use [man]array_reverse/man. However, this is just extra work.

[urbley]

Thanks for the quick reply. yeah I've already created the new field in the table. It was just really for future reference and thanks again.

Steve