Quick sorting question

[Anon]

Hi,

I want to give the user the option to re-sort search results. Is there a simple way of sorting the records in the recordset (perhaps using some SQL construct)? Or is it necessary to execute another query against the database?

Thanks,

Sonny

[Anon]

If you're doing this based on a user request, aren't you going to have to re-query the database anyway? Or ... are you storing the recordset with a session, or something? Perhaps I'm missing something...

-Keegan

[Anon]

Read the MySQL manual about the ORDER BY and GROUP BY clauses.

SELECT * FROM table ORDER BY firstname asc;

this will order the results by firstname in ascending order.

Note: you can only use SQL to sort during the query, not after the query has been done. (so you can't take a resultset and re-order it before you mysql_fetch_array().