[Resolved] Group Results & Display Record

[GIJew]

Hi All,

So I am working on a link manager and I got everything up and running except for the actual displaying of the links in the database.

What I want to do is grab all of the links from the database for the current user and display them in categories.

My table has the following columns:
- id
- link_cat
- link_name
- href
- title
- owner

My Query
$sqlLinks = MySQL_Query ("SELECT * FROM links WHERE owner = '$user' GROUP BY link_cat ORDER BY link_name ASC");

So basically what I am looking for after this is the code to display every link associated with each category for the current user.

I'm not sure if I should go the array route or a for/foreach loop. Any help would be greatly appreciated and please include code to give me a better idea of how to do this.

Thanks!

[GIJew]

Solved it!

$sqlCat = MySQL_Query("SELECT cat_name FROM linkcats ORDER BY cat_name"); 

while($cat = mysql_fetch_array($sqlCat)) {
  echo '<b>'.$cat['cat_name'].'</b><br>';
  $sqlLinks = MySQL_Query("SELECT * FROM links WHERE link_cat = '". $cat['cat_name'] ."' AND owner = '$user'");
  while($link = MySQL_Fetch_Array($sqlLinks)) {
    echo $link['link_name'].$link['owner'].'<br>';
  }
}