require_once("../conn.php");
require_once("access.php");
//get the categories
$q1 = "select * from yellow_categories order by CategoryName";
$r1 = mysql_query($q1) or die(mysql_error());
if(mysql_num_rows($r1) == '0')
{
echo "
CLASSIFIEDS v2.0
|
LIST CATEGORIES | ||
Categories | Listings | Action |
$a1[CategoryName] | \n\t"; //get the category listings $q2 = "select count(*) from yellow_posts where CategoryID = '$a1[CategoryID]' "; $r2 = mysql_query($q2) or die(mysql_error()); $a2 = mysql_fetch_array($r2); echo "$a2[0] | \n\tedit | add subcat | delete | \n