menu tree and mysql help

[slimjim]

WHat i need help on is this, I want to be able to show subcategories of a categorie if folder.gif is clicked on. Right now if folder.gif is clicked on, the dfolder.gif shows and i am thinking this should be easy, but cant figure it out.

<?
			$sql="select * from toolscategory";
	        $res=mysql_query($sql);
			while($obj=mysql_fetch_object($res))
			{
			$groupname=$obj->catname;
			$cid=$obj->categoryid;
			if($cid==$catid)$img="<img src='images/folder.gif'>";else $img="<img src='images/clfolder.gif'>";
			?>
            <tr valign="middle"> 
              <td width="4%" height="25" align="left" >&nbsp;</td>
              <td height="25" align="left" class="normal">
			  <? print "$img&nbsp;<a href='index.php?catid=$cid'>$groupname</a>(".getNumtips($cid).")";?>
				</td>
            </tr>
			<?
			}
			?>

[chads2k2]

Ok I did this in a similar fashion ... however the problem is a bit different.

Let me show you the code to take a category's ID and then call all the subcategories that go with it. They are setup in two different tables with the same database. See if this code can help you. Thanks!

<?php

        // This is an include of the connection strings.
        include("connection.inc");

			// First I get everything from categories.
        $sql = "select * from categories";
        $result = mysql_query($sql);
        while ($row = mysql_fetch_array($result)) {
        		// I then get the category_id.
              $category_id = $row['category_id'];
              $category_name = $row['category_name'];

					// This just outputs the category name
              echo "\r\r<p><strong>$category_name<br>";

					// Now we call the subcategories table and search ref_cat for the category_id.
					// My table structure:
					//
					// -----------------------
					//   sub_id INT NOT NULL AUTO_INCREMENT (PRIMARY KEY)
					//   sub_title TEXT  (The title of the sub-category)
					//   ref_cat TEXT (referring category number)
					// ------------------------
					//
              $sqla = "select * from subcategories where ref_cat='$category_id'";
              $resulta = mysql_query($sqla);
              while ($row = mysql_fetch_array($resulta)) {
                    $sub_id = $row['sub_catid'];
                    $sub_title = $row['sub_title'];
                    echo "\r<input name='checkbox[]' type='checkbox' class='text_boxes_contractor' value='$sub_id'></strong>$sub_title<br>";

              }
        }
        ?>

the \r's will just make the source code cleaner to read. Just FYI (incase you didn't know).