<h3>Main Categories</h3>
<ul class="nav">
  <?php
						$catQ="select id,title from tbl_data where id=p_id order by title asc";
						$resultCat=mysql_query($catQ) or die($catQ);
						while($rowObj=mysql_fetch_object($resultCat))
						{
								
							$pid="";
							$pid=$rowObj->id;
							$countResult=mysql_query("SELECT COUNT(*) AS countSubCat FROM tbl_data WHERE id!=p_id AND p_id='$pid'");
							$countObj=mysql_fetch_object($countResult);
							$countSubCat=$countObj->countSubCat;
							if(strlen($rowObj->title)>15)
							{
								echo "<li><a href='sub-category.php?id=$pid'>".substr($rowObj->title,0,18)."..(".$countSubCat.")</a></li>";
							}
							else
							{
								echo "<li><a href='sub-category.php?id=$pid'>".$rowObj->title."(".$countSubCat.")</a></li>";
							}	
						
						}

?>
</ul>

<h3>Categories</h3>
<ul class="nav">
  <?php
  
  					if(isset($_REQUEST['id']))
					{
						$id=$_REQUEST['id'];
						$catQ="select id,title from tbl_data where id='$id' order by title asc";
						$resultCat=mysql_query($catQ) or die($catQ);
						while($rowObj=mysql_fetch_object($resultCat))
						{
								if(isset($_REQUEST['id']) && $_REQUEST['id']==$rowObj->id)
								{
									$pid="";
									$pid=$rowObj->id;
									$countResult=mysql_query("SELECT COUNT(*) AS countSubCat FROM tbl_data WHERE id!=p_id AND p_id='$pid'");
									$countObj=mysql_fetch_object($countResult);
									$countSubCat=$countObj->countSubCat;
									if(strlen($rowObj->title)>15)
									{
										echo "<li><a href='sub-category.php?id=$pid' ><font color='green'><b>".substr($rowObj->title,0,18)."..(".$countSubCat.")</b></font></a></li>";
									}
									else
									{
										echo "<li><a href='products.php?id=$pid' ><font color='green'><b>".$rowObj->title."(".$countSubCat.")</b></font></a></li>";
									}
									
									$catSubQ="select id,title from tbl_data where id!=p_id AND p_id='$pid' order by title asc";
									$resultSubCat=mysql_query($catSubQ) or die($catSubQ);
									if(mysql_num_rows($resultSubCat)>0)
									{
										while($catSubObj=mysql_fetch_object($resultSubCat))
										{
											$sid=$catSubObj->id;
											$countResult=mysql_query("SELECT COUNT(*) AS countSubCat FROM tbl_data WHERE id!=p_id AND p_id='$sid'");
											$countObj=mysql_fetch_object($countResult);
											$countSubCat=$countObj->countSubCat;
											if(strlen($catSubObj->title)>15)
											{
												echo "<li><a href='sub-category.php?id=$sid' ><font color='red'>".substr($catSubObj->title,0,16)."..(".$countSubCat.")</font></a></li>";
											}
											else
											{
												echo "<li><a href='sub-category.php?id=$sid' ><font color='red'>".$catSubObj->title."(".$countSubCat.")</font></a></li>";
											}	
										}
									}
								
								
								}
								else
								{
									$pid="";
									$pid=$rowObj->id;
									$countResult=mysql_query("SELECT COUNT(*) AS countSubCat FROM tbl_data WHERE id!=p_id AND p_id='$pid'");
									$countObj=mysql_fetch_object($countResult);
									$countSubCat=$countObj->countSubCat;
									if(strlen($rowObj->title)>15)
									{
										echo "<li><a href='sub-category.php?id=$pid'>".substr($rowObj->title,0,18)."..(".$countSubCat.")</a></li>";
									}
									else
									{
										echo "<li><a href='sub-category.php?id=$pid'>".$rowObj->title."(".$countSubCat.")</a></li>";
									}	
								}	
						
						
						}

					}
					else
					{
						$catQ="select id,title from tbl_data where id=p_id order by title asc";
						$resultCat=mysql_query($catQ) or die($catQ);
						while($rowObj=mysql_fetch_object($resultCat))
						{
								
							$pid="";
							$pid=$rowObj->id;
							$countResult=mysql_query("SELECT COUNT(*) AS countSubCat FROM tbl_data WHERE id!=p_id AND p_id='$pid'");
							$countObj=mysql_fetch_object($countResult);
							$countSubCat=$countObj->countSubCat;
							if(strlen($rowObj->title)>15)
							{
								echo "<li><a href='sub-category.php?id=$pid'>".substr($rowObj->title,0,18)."..(".$countSubCat.")</a></li>";
							}
							else
							{
								echo "<li><a href='sub-category.php?id=$pid'>".$rowObj->title."(".$countSubCat.")</a></li>";
							}	
						
						}
					}	
					

?>
</ul>