sorting mysql results

From: 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.

« previous php.general (#206025) next »