PHP & MYSQL - Group by request

How to echo the name of the group.

[tomda]

Hi,

If my db is like this
NAME - CATEGORY
Ex1 - A
Ex2 - B
Ex3 - A
Ex4 - B

and I group the result by category, I get :
Ex1 Ex3 Ex2 Ex4

But I want this:
A - Ex1 Ex3
B - Ex2 Ex4

Is there a simple way to echo the name of the category before showing the grouped results?

Thanks

[coopster]

Monitor for the group change in your processing loop and if it did indeed change, echo it to the browser.

[tomda]

>> Monitor for the group change in your processing loop and if it did indeed change, echo it to the browser.

Thanks for your suggestion.

I knew I could do something like you said but I though that they would be an easy php function (may be with array) to check for group change.

// CHECK IF CATEGORIES MATCH
if ($record_previous!=$record["category"]) {
echo $record["category"];}

// WRITE THE NAME
echo $record["name"];

// SET A VARIABLE
$record_previous=$record["category"];