[SOLVED] PHP/MySQL grouping into category

[cordoprod]

Hello!

I have a user management system, and i am struggling with the friends section.

 

I have a DB called friends.

The structure is like this: category, friend, friend2, friend_text, friend2_text

 

What i want to do, but can't figure out, is to list all the entries, but by grouping it into category.

 

Like this:

category1

--

friend

friend

friend

 

category2

--

friend

friend

friend

 

 

If you understand? I just want to know how the SQL is going to look like.

[premiso]

SELECT category, friend, friend2, friend_text, friend2_text FROM friends GROUP BY category

 

That should do it.

 

Instead of a group by, however, you could just use ORDER BY category, and that should work.

[cordoprod]

Yes i have tried that, but should i output it with while(mysql_fetch and so on.... as usual then?

What do i need to put inside the while()?

[premiso]

<?php

while ($row = mysql_fetch_assoc($result)) {
    if ($last_cat != $row['category']) {
           echo "<br />" . $row['category'] . "<br />--<br />";
           $last_cat = $row['category'];
    }
    
    echo $row['friend'] . "<br />";
}
?>

[cordoprod]

Thanks, i'll give it a try.

[cordoprod]

THANKS!!!!!!!!!!!! 

I have been struggling with this for a loooooooooong time!