Categories
| \n"; while($row=mysql_fetch_array($result)) { $count=$count+1; $id=$row["id"]; $sub_cat=$row["sub_cat"]; $name=$row["name"]; $dsc=$row["dsc"]; $link_count = MySQLQuery("SELECT * FROM links WHERE cat_id='".$id."' AND approved='yes' ORDER BY name ASC", $QueryError_Email,$QueryError_Browser); $link_count=mysql_num_rows($link_count); if($link_count==1){$link_text="";}else{$link_text="";} if($count <= $front_cols && $count==1){echo " | |||||
| \n";} else if($count < $front_cols && $count > 1){echo " | \n | \n";} else if($count==$front_cols){echo " | \n | \n";}
echo "$name ($link_count $link_text)\n";
$result2 = MySQLQuery("SELECT id,sub_cat,name FROM links_cat WHERE sub_cat='$id' ORDER BY name ASC", $QueryError_Email,$QueryError_Browser);
if(mysql_num_rows($result2))
{
echo " "; while($row2=mysql_fetch_array($result2)) { $id2=$row2["id"]; $sub_cat2=$row2["sub_cat"]; $name2=$row2["name"]; $link_count = MySQLQuery("SELECT * FROM links WHERE cat_id='".$id2."' AND approved='yes' ORDER BY name ASC", $QueryError_Email,$QueryError_Browser); $link_count=mysql_num_rows($link_count); if($link_count==1){$link_text="link";}else{$link_text="links";} echo "$name2 ($link_count):\n"; } echo ""; } if($count <= $front_cols && $count==1){echo " \n | \n";}
else if($count < $front_cols && $count > 1){echo "\n"; } echo " |
No categories found
"; } ?>