Creating a Cascading List

[homchz]

I have the current code (there maybe a better way to do this but being new this is what I have come up with 🙂 ).

<?php
///Connect To Database
mysql_connect("localhost","username","password");
mysql_select_db("database");

////Main Forum Query////
$results_MainForum = mysql_query("SELECT * FROM ibf_forums WHERE parent_id = 25 ORDER by id ASC");
if (mysql_num_rows($results_MainForum) > "0")
	{
		while ($row_MainForum = mysql_fetch_array($results_MainForum))
			{   

				$main_forum = $row_MainForum['name'];
				$forum_id = $row_MainForum['id'];
				////Sub Forum Query////
				$results_SubForum = mysql_query("SELECT * FROM ibf_forums WHERE parent_id = $forum_id ORDER by id DESC");
					if (mysql_num_rows($results_SubForum) > "0")
						{
							while ($row_SubForum = mysql_fetch_array($results_SubForum))
							{   

								$subforum_id = $row_SubForum['id'];
								$subforum_name = $row_SubForum['name'];
								////Article Query////
								$results_Articles = mysql_query("SELECT * FROM ibf_topics left join ibf_posts on ibf_topics.tid = ibf_posts.topic_id WHERE ibf_topics.forum_id = $subforum_id ORDER BY ibf_topics.start_date ASC");
									if (mysql_num_rows($results_Articles) > "0")
									{
										while ($row_Articles = mysql_fetch_array($results_Articles))
											{
												$articles = $row_Articles['title'];
												///Print List///
												print "$main_forum<br>";
												print "&nbsp;$subforum_name<br>";
												print "&nbsp;&nbsp;$articles<br>";

										}
								}		
						}
					}

		 }
 }

?>

I am trying to make a cascading list and for the most part it is working just fine and pulling the info that I want except it is listing the Main and Sub Titles more than one for each article.

This code presents this result

---

Activism
Florida Road
MA Forrest Association mtg, January 22nd
Activism
Florida Road
testing
Tech Articles
General Tech

Submarining Your Rig

When what I really want is:

---

Activism
Florida Road
MA Forrest Association mtg, January 22nd
testing
Tech Articles
General Tech

Submarining Your Rig

Any thoughts?

Thanks

Josh

[_Demonoid_]

I'm not quite sure what you're trying to do, but maybe you should have a function such as function GetSubForums($ForumID), and this gets all the sub-forums of $ForumID. It would then call itself for each sub-forum, with the ID of that sub-forum. Then, you would just call GetSubForums(ID of the base forum), and it would do the rest for you.

[mtmosier]

Easiest way is to print the main forum and sub forum names right where you grab them from the db. Such as this:

$main_forum = $row_MainForum['name'];
$forum_id = $row_MainForum['id']; 
print "$main_forum<br>";

That has the obvious drawback that the main forum will be printed regardless of whether there are any subforums in it, and both main and subforums will be printed even if there are no articles in them. If thats an issue (and why do I think it is?), then check a boolean to see if you've printed the forum names already during each pass.

$main_forum = $row_MainForum['name'];
$forum_id = $row_MainForum['id']; 
$main_forum_printed = false;

[...]

    ///Print List///
    if (!$main_forum_printed) {
        print "$main_forum<br>";
        $main_forum_printed = true;
    }
    if (!$subforum_printed) {
        print "&nbsp;$subforum_name<br>";
        $subforum_printed = true;
    }
    print "&nbsp;&nbsp;$articles<br>"; 

(I assume you can fill in the holes.)

[homchz]

Thank-you for the information it worked great.

I was starting to over think it again, but this made it much more simple.

Josh