Tables

[loony383]

Hi i want to select categorys from the table forumtutorial_cats and then it will select forums from forumtutorial_subforums where catid=the catid from the previous query. in a table it would list the category name then all the forums underneith it then it would list the 2nd categorys name and the forums underneith it. it would keep doing thin until it didn't find any more categorys. i am not sure how i would get it to do this. if someone can write me an example of this i would be very greatful.

[Wes1890]

for ($cat=0;$cat<$total_cats;$cat++)
{
  // use mysql here to select all the forums inside of $cat

  for ($forum=0;$forum<$total_forums;$forum++)
  {
    echo $forum;
  }

}

 

that is a basic outline, but thats exactly how you can go about doing it

[loony383]

where would i put the query that gets the categorys?

[Wes1890]

grab them (and count how many total) from the DB or whatever your using, before the first FOR statement is made

[loony383]

so it would see how many categorys there are then it would go through them doing a seperate query for each category until there are no more to query?

[Wes1890]

^ yes, but be sure to have an ID field in each category's table-row or else it will be hard to work with the numbers that the FOR statements will be giving out