The listings information was updated successfully.
Click here to delete this category."; exit(); } if(!empty($_GET[CategoryID])) { if($_GET[n] == '0') { //delete subcategory's info $q1 = "delete from yellow_categories where CategoryID = '$_GET[CategoryID]' "; mysql_query($q1) or die(mysql_error()); header("location:categories.php"); } else { include_once("LeftStyles.php"); //show the listings at this category $q1 = "select * from yellow_listing, yellow_agents, yellow_priority,yellow_posts where yellow_posts.CategoryID = '$_GET[CategoryID]' and yellow_posts.AgentID = yellow_agents.AgentID and yellow_agents.PriorityLevel = yellow_priority.PriorityLevel and yellow_agents.AccountStatus = 'active'"; //$q1 = "select * from yellow_listing, yellow_priority, yellow_agents where yellow_agents.CategoryID = '$_GET[CategoryID]' and yellow_agents.PriorityLevel = yellow_priority.PriorityID "; $r1 = mysql_query($q1) or die(mysql_error()); ?>  

CLASSIFIEDS v2.0

 

$a1[PriorityName]"; $MySelect = "\n\t"; $qcat = "select * from yellow_categories order by CategoryName"; $rcat = mysql_query($qcat) or die(mysql_error()); while($acat = mysql_fetch_array($rcat)) { if($acat[CategoryID] != $_GET[CategoryID]) { $MySelect .= "$acat[CategoryName]\n\t"; } } $MySelect .= "\n"; echo "\n\t\n\t\n\n"; } echo "\n\t\n\n"; echo "

These listings still appear at the category you want to delete. Move them to another category and than you will be able to delete the existing one.

Title & Description	New category
$a1[username] $a1[CompanyName]	$MySelect

\n\n

\n\n"; } } ?>