Sort when querying from database:
SELECT name, type FROM some_table ORDER BY type ASC, name ASC
----- Original Message ----- From: "Sebastian" <sebastian@xxxxxxxxxxxxxxxxxxx>
To: <php-general@xxxxxxxxxxxxx>
Sent: Tuesday, January 11, 2005 5:38 AM
Subject: sorting mysql results
I have a list of rows in the database and i would like to sort them in two categories. example,
echo $row['name'] . '-' . $row['type'];
// output:
row 1 - files
row 2 - files
row 3 - music
row 4 - files
I would like this output:
files ---------- row 1 - files row 2 - files row 4 - files
music ----------- row 3 - music
if the $row['type'] is music i want to output an <hr> and the results below
it but below the files results.. makes sense?
i thought i remember doing this once using a dummy var but cant remember
how. i guess i could always run a second query, but would like to avoid
that.
thanks for any help.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
