Formatting problems

Archbob

Hey, I'm trying to write a directory so I got this code:

if (isset($catID)){ // looking at specific category
                 print "<table width=95%> <tr height=100%><td valign=top width=25% bgcolor='#e1e1e1'> ";
$r=mysql_query("SELECT * FROM cl_categories Where CatParent='NADA'", $db) or die("4");
		while ($res = mysql_fetch_array($r))
			print "<a href='index.php?catID=$res[CatID]'>$res[CatName]</a><br>";
print"</td>";
print "<td width=75% valign=top> <br>";
print "<center><b>Sub- Categories</b></center><br><br>";



$r=mysql_query("SELECT * FROM cl_categories WHERE CatParent='$catID'", $db) or die("1");
while ($res = mysql_fetch_array($r))
	print "<a href='index.php?catID=$res[CatID]'>$CatName</a><br>";
print "<br><center><b>Entries</b></center><br><br>";
	$r=mysql_query("SELECT * FROM cl_entries WHERE CatID='$catID'", $db) or die("2");
	while ($res = mysql_fetch_array($r))
		print "<a href='index.php?entryID=$res[entryID]'>$res[EntryName]</a><br>";
print "</td></tr></table>";

The problem is the table just isn't appearing and only the entries are showing and the main categories aren't showing in the left columns. I can't see a mistake here with my formatting.

philhale

First, the IF statement has an open paren but not a closing paren. Check on this.

Second, assign the $res['CatID'] to a single variable before using it in the print command.

Third, add a border to the table command if you can't see the table itself.

Fourth, indent your code in blocks to make it easier to read and debug. For example, after an IF, or after a WHILE, or after a FOR.

Best of luck!

Phil.

Archbob

Thanks,
I'll look into it.

philhale

I apologize for the way that last comment sounded. It was kind of snootty of me -- not the person I want to be.

I do wish you the best in your development efforts.

Phil.

Archbob

I fixed it, I forgot to change index to index2 for the individual iffsets, stupid me.

planetsim

Everyone makes mistakes