subcat problem can anyone help?

[raven2009]

hi all

ive been learning php doing well so far until... i come to the subcategories

 

right what i aim to do is that the left pannel displays the maincat then if a user clicks on a main cat that has a subcat then the cat menu expands to enclude both, heres my code below to see where ive gone wrong any help will be much appriciated )

 

 

 

<?php

$categories="select * from categories where parent='0' order by id";

$listCats=mysql_query($categories);

 

while($row=mysql_fetch_array($listCats))

{

 

?>

<tr>

<td height="15" bgcolor="#006699"><h5><img src="Images/arrwo_4.png" alt="" width="10" height="7" /></h5></td>

<td bgcolor="#006699"><h5><a href="storesinfo.php?s=<?php echo $row['id']; ?>" class="White"><font color=""><?php echo $row['category']; ?></font></a></h5></td>

</tr>

<?php

$parId=$row['id'];

$childCategories="select * from categories where parent='$parId' order by id";

$listChildCategories=mysql_query($childCategories);

while($rowC=mysql_fetch_array($listChildCategories))

{

?>

<tr>

<td height="15" bgcolor="#009900"><h5> </h5></td>

<td bgcolor="#009900"><h5><a href="storesinfo.php?s=<?php echo $rowC['id']; ?>" class="White"><font color=""><?php echo $rowC['category']; ?></font></a></h5></td>

</tr>

<?

}

 

}

?>

<?php

if(isset($_GET['p']))

{

$p=$_GET['p'];

$categories="select * from categories where parent='$p'";

}

else

{

$categories="select * from categories";

}

$listCats=mysql_query($categories);

 

while($row=mysql_fetch_array($listCats))

{

 

?>

<?php

[raven2009]

sorry all ill explain better 

 

main cat is displayed constant then if user clicks on a main cat that has a sub cat then the subcat will open

 

is it possible?

[Yesideez]

Please surround code with CODE tags to help preserve formatting.

[raven2009]

sorry, dunno if this is right but he it goes

 

<?php
$categories="select * from categories where parent='0' order by id";
$listCats=mysql_query($categories);	

while($row=mysql_fetch_array($listCats))
{

?>
                                    <tr>
                                      <td height="15" bgcolor="#006699"><h5><img src="Images/arrwo_4.png" alt="" width="10" height="7" /></h5></td>
                                      <td bgcolor="#006699"><h5><a href="storesinfo.php?s=<?php echo $row['id']; ?>" class="White"><font color=""><?php echo $row['category']; ?></font></a></h5></td>
                                    </tr>
                                    <?php
$parId=$row['id'];				
	$childCategories="select * from categories where parent='$parId' order by id";
$listChildCategories=mysql_query($childCategories);	
	while($rowC=mysql_fetch_array($listChildCategories))
{	
?>
                                    <tr>
                                      <td height="15" bgcolor="#009900"><h5> </h5></td>
                                      <td bgcolor="#009900"><h5><a href="storesinfo.php?s=<?php echo $rowC['id']; ?>" class="White"><font color=""><?php echo $rowC['category']; ?></font></a></h5></td>
                                    </tr>
                                    <?
}

}
?>
                                    <?php
if(isset($_GET['p']))	
{
$p=$_GET['p'];
$categories="select * from categories where parent='$p'";
}
else
{
$categories="select * from categories";
}
$listCats=mysql_query($categories);	

while($row=mysql_fetch_array($listCats))
{

?>
                                    <?php
}
?>

[raven2009]

anyone?  ???

[raven2009]

no?  :'(