Looping Queries in a message board

[Archbob]

Hey, you know for board system such as vB and Invisionboard they have category and forum under the category.

Now I have implemented this with a while loop and querying inside the loop. Like:

while($row=query)
{
   $s="SELECT * from forums where catID=$row[ID]";
   mysql_query($s);
   //displays forum of that catgory
}

this works just fine but results in alot of queries if there are alot of cateogories. Is there a way to order forums by category with only one query?

[scoppc]

The best choice is to have category table where all categories are kept here and link it with forum table by using the ID.
You can use DISTINCT if you dont have two separate tables.

[Archbob]

Well, I know I can do that, but I want a expanded appearance like this board. How I display all the forum under the categories without a double loop, is it possible?