'; //var_dump($_POST); if ((int)count($_POST["del"]) > 0) { $ids = implode(", ", $_POST['del']); if ($_POST['move_btn'] != "") { $sql = "UPDATE oliverAds SET approved='t' WHERE id in ($ids)"; $result = mysql_query($sql, $conn) or die(mysql_error()); } else if ($_POST['delete_btn'] != "") { $sql = "DELETE FROM oliverAds WHERE id in ($ids)"; $result = mysql_query($sql, $conn) or die(mysql_error()); } // echo 'aaa'.$sql; $admin = true; } ?> approved adds

Manage Ad list

".str_replace("_", " ", $rs['category'])."

"); $sql = "select * from oliverAds where approved='f' AND category = '".$rs['category']."' order by id"; // echo($sql); $secondResult = mysql_query($sql, $conn) or die(mysql_error()); while($rs2 = mysql_fetch_array($secondResult)) { $datePosted = str_replace("-", "/", substr($rs2['datePosted'], 5)); $datePosted .= "/".str_replace("-", "/", substr($rs2['datePosted'], 0, 4)); ?>
# Post Date:
Category:
Machine Type:
Model:
Serial No:
Capacities:
Dimensions:
Weight:
Motor:
Accessories:
Location:
Comments: ", $rs2['comments'])) ?>
Price:
Phone No:
Contact Name:
E-mail:
Accepts Terms:
"); print(""); print(""); print(""); print(""); print(""); print("#".$rs2['id'].""); print(""); print($datePosted."
"); print($rs2['machineType']." Model#".$rs2['modelNumber'].", SN#".$rs2['serialNumber']."
"); print("Price: ".$rs2['price']."
"); print("Contact ".$rs2['contactName']." - "); print($rs2['phone']." or "); print("".$rs2['email'].""); print(""); print(""); print(""); */ } } ?>




Name:
Password: