$error .= "- User's Sold Block must be a valid PNG file.<br>"; } } return $error; } #################### function is_default() { if ($_REQUEST[banner_id] == 1) { return true; } return false; } ##################### if ($_REQUEST['action'] == 'delete') { if (is_default()) { echo "<b>Cannot delete</b> - This is the default grid!<br>"; } else { // check orders.. $sql = "SELECT * FROM orders where status <> 'deleted' and banner_id=" . $_REQUEST['banner_id']; //echo $sql; $res = mysql_query($sql) or die(mysql_error()); if (mysql_num_rows($res) == 0) { $sql = "DELETE FROM blocks WHERE banner_id='" . $_REQUEST['banner_id'] . "' "; mysql_query($sql) or die(mysql_error() . $sql); $sql = "DELETE FROM prices WHERE banner_id='" . $_REQUEST['banner_id'] . "' "; mysql_query($sql) or die(mysql_error() . $sql); $sql = "DELETE FROM banners WHERE banner_id='" . $_REQUEST['banner_id'] . "' "; mysql_query($sql) or die(mysql_error() . $sql); // DELETE ADS $sql = "select * FROM ads where banner_id='" . $_REQUEST['banner_id'] . "' ";
</tr> <tr> <td title="Filter users" data-rel="tooltip"> <select name="show_what" type="text"> <option value="show_everyone" <?php echo is_default("show_everyone"); ?> >show everyone</option> <option value="show_banned" <?php echo is_default("show_banned"); ?> >show only banned users</option> <option value="show_unbanned" <?php echo is_default("show_unbanned"); ?> >show only unbanned users</option> </select> </td> </tr> <tr> <td title="No of users per page" data-rel="tooltip"><input name="users_per_page" type="text" id="users_per_page" placeholder="5"/></td> </tr> </table> <button type="submit" value="submit" class="btn">Filter</button>