Posted by Andrew Kreps on 10/04/22 11:05

On Mon, 10 Jan 2005 16:38:18 -0500, Sebastian
<sebastian@broadbandgaming.net> wrote:
> 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
>

add order by `type` to your sql statement, and then put something like
the following in your mysql loop:

// initialize $prevType above

if ($prevType !== $row['type'])
{
print "<hr>" . $row['type'] . "------<br>"; // Or whatever you
want the header to look like
}
$prevType = $row['type'];

That should do the trick.

[Back to original message]