ok well ive basically takes takes the table name and id from the user and then delets it from the database here is my part of the script. <?php $delete_item_code = mysql_escape_string($_POST['delete_item_code']); if(isset($_POST['Delete'])) { if (!isset($_POST['delete_item_code']) || trim($_POST['delete_item_code']) == "" ) { echo "<span class=\"red\">Please enter a stock code</span>"; } else if(empty($deletetable)) { echo "<span class=\"red\">Please Select a Table</span>"; } else { $sqlquery="DELETE FROM `$deletetable` WHERE item_code = $delete_item_code "; $resultdelete=mysql_query($sqlquery); echo mysql_error(); echo "<div id=\"added\"><span class=\"font\">Your stock item $item_code has been Deleted</span></div>"; } } ?> Code (markup): However if it doesn't delete a item for example the item number doesn't exist it doesnt give me a warning does anyone know any ways i can give the usr a warning if the id doesn't exit within the table.
if (!mysql_affected_rows()) { echo 'No item was deleted.'; } else { echo 'Item successfully deleted.'; } PHP: www.php.net/mysql_affected_rows