[RESOLVED] generating a list within a list

deepthroat

Not quite sure how to explain this properly but here goes.....

Im trying to render lists within other lists using php/mysql.

So for exaple I want to end up with a page looking like this:

Category 1
___Page 1
Page 2
___Page 3

Category 2
___Page 1
Page 2
___Page 3

Category 3
___Page 1
___Page 2

and so on. The same way as this page: http://www.phpbuilder.com/board/index.php. Like generating the forums lists within category's lists.

Thisis the code I have tried to use:

// SEARCH QUERY FOR CATEGORYS -------------------------------------------
$GetCat = "SELECT * FROM category";
$ResultList = mysql_query($GetCat) or die ("problem with query:".mysql_error());
$TableRows = mysql_num_rows($ResultList);


// SEARCH QUERY FOR CATOGORYS -------------------------------------------
$GetPages = "SELECT * FROM pages";
$ResultForums = mysql_query($GetPages) or die ("problem with query:".mysql_error());
$PageRows = mysql_num_rows($ResultPage);



echo "<table border=\"1\">\n";

$i = 0;
while ($i < $TableRows)
{

$cid = mysql_result($ResultList,$i,"CAT_ID");
$cstatus = mysql_result($ResultList,$i,"CAT_STATUS");
$cname = mysql_result($ResultList,$i,"CAT_NAME");
$corder = mysql_result($ResultList,$i,"CAT_ORDER");

// LIST CATEGORYS ------------------------------------------------
echo "<tr><td><i>$cid</i>&nbsp;<b>$cname</b></td></tr>\n";
echo "<tr><td>\n";

// LIST PAGES------------------------------------------------
echo "<table border=\"1\">\n";

$i = 0;
while ($i < $PageRows)
{

$pid = mysql_result($ResultPage,$i,"PAGE_ID");
$psubject = mysql_result($ResultPage,$i,"P_SUBJECT");
$pdesc = mysql_result($ResultPage,$i,"P_DESCRIPTION");

echo "<tr><td>$pid&nbsp;-&nbsp;$psubject<br>pfdesc</td></tr>\n";

$i++;
}
echo "</table>\n";
// END LIST PAGES-------------------------------


echo "</td></tr>\n";

$i++;
}
echo "</table>\n";

(I know the code is a little rough, but im just testing at this stage)
But with this code whats happening is, its displaying
Category 1 as it should, then its displaying the pages list within category 1.....
but then it stops!
It doesnt go on to display category 2 ot any of its lists or other categorys.

Perhaps it isnt possible to have list within another list like I have tried to do?

bpat1434

haha I had this whole thing written out, and vBulletin automatically logged me out. Stupid PHP software.... I'll take time to repost it again....

The following code should output something like this:

1 Category 1
[INDENT]1 - Page 1
A description of page 1[/INDENT]
[INDENT]2 - Page 2
A description of page 2[/INDENT]
[INDENT]3 - Page 3
A description of page 3[/INDENT]
2 Category 2
[INDENT]4 - Page 1
A description of page 1[/INDENT]
[INDENT]5 - Page 2
A description of page 2[/INDENT]
[INDENT]6 - Page 3
A description of page 3[/INDENT]

<table>
	<?php
	$sql1 = "SELECT * FROM categories";
	$result = mysql_query($sql1);
	while($row = mysql_fetch_array($result))
	{
		?>
		<tr><td><i><?php echo $row['CAT_ID']; ?></i> <b><?php echo $row['CAT_NAME']; ?></b></td></tr>
		<tr><td>
			<table>
			<?php
			$sql2 = "SELECT * FROM pages WHERE p_category = '".$row['CAT_ID']."'";
			$rslt2 = mysql_query($sql2);
			while($row2 = mysql_fetch_array($rslt2))
			{
				?>
				<tr><td><?php echo $row['PAGE_ID'].' - '.$row['P_SUBJECT']; ?><br>
				<?php echo $row['P_DESCRIPTION']; ?></td></tr>
				<?php
			}
			?>
			</table>
		</td></tr>
		<?php
	}
	?>
</table>

deepthroat

Thank you very much for your help.... nearly there but not quite.

Where echoing out the "page" details I changed $row to $row2 (as should be). But this still doesnt work. All it is doing is rendering the category's but not the pages within.

<table>
<?php
$sql2 = "SELECT * FROM pages WHERE p_category = '".$row['CAT_ID']."' ";
$rslt2 = mysql_query($sql2);
while($row2 = mysql_fetch_array($rslt2))
{

Now.... if I take away the part in red, it kinda works, it does render the pages withn category's but of course it renders ALL the pages in ALL of the categorys, not specific pages to the specific categorys as should be.

So im suspecting that the part I have highlighted in red is at fault. Looking at it it SHOULD work.... but perhaps there needs to be something before the part in red, because the part in red just isnt quirying as it should.

thanks again for your help! 😃

bradgrafelman

You might want to visit the Debugging 101 thread (link in my sig) which deals with debugging MySQL queries/dilemmas, but here's a couple of suggestions.

echo() out $sql2 variable when you have the part in red in your query. Look at it visually (in your browser) and see if it looks right. See if everything's getting filled in correctly and whatnot.
When you query the DB using the part in red, try adding an "or die()" statement onto your mysql_query() statement. More info on this including examples is available in the Debugging 101 thread.

deepthroat

thanks, but I have already tried and tested all the basics like those, but it literally doesnt do anything.
Its just ignoring the part in red.

deepthroat

this is now resolved..... the error was due to incorrect data in my dataabse! OOoppss.

Thanks bpat!

bradgrafelman

Don't forget - there's a "Mark Thread Resolved" feature under the "Thread Tools" menu!

Glad you got it working.

bpat1434

Glad to hear you got it working.

~Brett