$catlink3[name] - $catlink3[url]
\n"; } else { print "$catlink3[name] - $catlink3[url]
\n"; } print "$catlink3[info]

"; } } } function sublink_goto($cat,$show_url,$subcat,$cat_name) { $cat_id = mysql_result(mysql_query("SELECT * from cats where name='$subcat'"),0,'catID'); $catlink="SELECT * from links where cat='$cat_id' and validated='1' order by name ASC"; $catlink2=mysql_query($catlink) or die("Unable to grab main catergories"); if(mysql_num_rows($catlink2) == '0') { print "Sorry there are no links"; } else { while($catlink3=mysql_fetch_array($catlink2)) { if($show_url == '1') { print "$catlink3[name] - $catlink3[url]
\n"; } else { print "$catlink3[name] - $catlink3[url]
\n"; } print "$catlink3[info]

"; } } } function cats($cat_col,$mod_rewrite) { $maincats="SELECT * from cats where subcat=0 order by name ASC"; $maincats2=mysql_query($maincats) or die("Unable to grab main catergories"); $add=0; while($maincats3=mysql_fetch_array($maincats2)) { if($mod_rewrite == '1') { $cat = "$maincats3[name]
\n"; } else { $cat = "$maincats3[name]
\n"; } if($add%$cat_col==0) { print "$cat\n"; } else if($add%$cat_col==1) { print "$cat\n"; } else { print "$cat\n"; } $add++; } } function sub_cats($cat_col,$mod_rewrite,$cat_name,$site_url) { $cat_id = mysql_result(mysql_query("SELECT * from cats where name='$cat_name'"),0,'catID'); $subcats="SELECT * from cats where subcat='$cat_id' order by name ASC"; $subcats2=mysql_query($subcats); $add=0; while($subcats3=mysql_fetch_array($subcats2)) { if($subcats3[catID] <= '1'){} //make sure there is subcats before starting, stops it coming up with '(, )' else { if($mod_rewrite == '1') //check for mod_rewrite, if not use ?cat=132&subcat=24 { $subcat = "$subcats3[name]
\n";// - $num_links } else { $subcat = "$subcats3[name]
\n"; } $subcat .= "$subcats3[info]

\n"; if($add%$cat_col==0) { print "$subcat\n"; } else if($add%$cat_col==1) { print "$subcat\n"; } else { print "$subcat\n"; } $add++; } } } ?>