update_sql ( "update listing set active=" . $_GET ['show'] . " where id=" . $_GET ['id'] ); //$db->print_last_query(); print ""; exit (); } if (isset ( $_GET ['d'] )) { $r = $db->select ( "select id,item_id from listing where id=" . $_GET ['d'] ); $row = $db->get_row ( $r, 'MYSQL_BOTH' ); $r1 = $db->select ( "SELECT path FROM item_images WHERE item_id = '" . $row ['1'] . "' order by id" ); while ( $row1 = $db->get_row ( $r1, 'MYSQL_BOTH' ) ) { unlink ( "../uploads/" . $row1 [0] ); } $db->delete ( "delete from items where id=" . $row ['1'] ); $db->delete ( "delete from item_images where item_id=" . $row ['1'] ); $db->delete ( "delete from listing where id=" . $row ['0'] ); //$db->print_last_query(); print ""; exit (); } if (! empty ( $_POST ['deleted_pdts'] )) { $r = $db->select ( "select id,item_id from listing where id IN(" . $_POST ['deleted_pdts'] . ")" ); while ( $row = $db->get_row ( $r, 'MYSQL_BOTH' ) ) { $r1 = $db->select ( "SELECT path FROM item_images WHERE item_id = '" . $row ['1'] . "' order by id" ); while ( $row1 = $db->get_row ( $r1, 'MYSQL_BOTH' ) ) { unlink ( "../uploads/" . $row1 [0] ); } $db->delete ( "delete from items where id=" . $row ['1'] ); $db->delete ( "delete from item_images where item_id=" . $row ['1'] ); $db->delete ( "delete from listing where id=" . $row ['0'] ); } //$db->print_last_query(); print ""; exit (); } ?>

Free Listing

select ( "select * from listing where listing_type='free' order by id desc LIMIT $limit" ); $numOfRows = $db->select_one ( "Select count(*) from listing where listing_type='free'" ); //$db->print_last_query(); while ( $row = $db->get_row ( $res, 'MYSQL_BOTH' ) ) { $p = $row ['0']; ?>

	Serial No	Category	Subcategory	Listing Title	Item Photo	Lister Name	Expiry Days	Actions
					"; else echo ""; ?>		"; //echo "now time".$t2." "; $t3 = $t2 - $t1; //echo "difference time".$t3." "; $day = ($t3 / 86400); // echo $day; $tab = explode ( '.', $day ); //echo $tab[0]; $expiry = 180 - $tab [0]; if ($expiry <= 0) echo "" . $expiry . ""; else echo $expiry; ?>	title="New Or Old Item">