Posted by Leif Gregory on 09/30/87 11:05

Hello Sebastian,

Monday, January 10, 2005, 2:38:18 PM, you wrote:
S> if the $row['type'] is music i want to output an <hr> and the
S> results below it but below the files results.. makes sense? i
S> thought i remember doing this once using a dummy var but cant
S> remember how. i guess i could always run a second query, but would
S> like to avoid that.

As you loop through the recordset, just concatenate.

i.e.

while ($r=mysql_fetch_assoc($result))
{
if ($row['type'] == "Music")
$musicRows .= $row['name'] . '-' . $row['type'] . '<br>';

elseif ($row['type'] == "Files")
$fileRows .= $row['name'] . '-' . $row['type'] . '<br>';

elseif ($row['type'] == "Pictures")
$pictureRows .= $row['name'] . '-' . $row['type'] . '<br>';
}

echo 'FILES<br>-----<br>' . $fileRows . '<br><br>';
echo 'MUSIC<br>-----<br>' . $musicRows . '<br><br>';
echo 'PICTURES<br>--------<br>' . $pictureRows . '<br><br>';


I threw PICTURES in there just for GPs.



Cheers,
Leif Gregory

--
TB Lists Moderator (and fellow registered end-user)
PCWize Editor / ICQ 216395 / PGP Key ID 0x7CD4926F
Web Site <http://www.PCWize.com>

• Prev in thread: Re: [PHP] sorting mysql results
• Next in forum: Re: [PHP] Re: What program to use to make thumbnail images?
• Prev in forum: Re: [PHP] sorting mysql results
• Thread view: Re: [PHP] sorting mysql results

[Reply to this message]