sorting mysql results
| From: | Sebastian | Date: | Mon, 10 Jan 2005 21:38:18 +0000 |
| Subject: | sorting mysql results | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-206025@lists.php.net to get a copy of this message | ||
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.