"; echo ""; if($Category > "0"){ echo ""; } echo ""; $sql = " select $tb_links.ID as link_id, $tb_links.SiteURL as site_url, $tb_links.SiteName as site_name, $tb_categories.Category as cat_name from $tb_links left join $tb_categories on $tb_categories.ID=$tb_links.Category where $tb_links.Category='$Category' limit $sr, $pp "; if($Category == "0"){ $sql = " select $tb_links.ID as link_id, $tb_links.SiteURL as site_url, $tb_links.SiteName as site_name, $tb_categories.Category as cat_name from $tb_links left join $tb_categories on $tb_categories.ID=$tb_links.Category where $tb_links.Category='0' or $tb_links.Category='' limit $sr, $pp "; } if($Category == "-1"){ $sql = " select $tb_temp.ID as link_id, $tb_temp.SiteURL as site_url, $tb_temp.SiteName as site_name, '' as cat_name from $tb_temp limit $sr, $pp "; } $result = sql_query($sql); while($rows = sql_fetch_array($result)){ echo ""; if($Category > "0"){ echo ""; } echo ""; } echo "

0){ echo "5"; } else { echo "4"; } echo "\">". nav_links($total_sites, $pp, $np, $cp, $nav_url) . "
Site Name	Category	"; if($Category == "-1"){ echo "Validate"; } else { echo "Edit"; } echo "	Reviews	Delete
"; echo stripslashes($rows[site_name]) . "	" . eregi_replace("_", " ", $rows[cat_name]) . "	"; if($Category == "-1"){ echo "Validate"; } else { echo "Edit"; } echo "	Reviews	Delete

"; } ?>