i have the following that i can delete my records with no problem but if you enter a records that doesnt exist then i need to be able to get a return value that tells the user you cant delete that cause it doesn't exist. with my SELECT statements or UPDATE i do $num=mysql_numrows($result); and test the vaule of $num, but i cant with the following
i want to be able to via the $result value see if the record even exist then i can tell the user that it either doesn't or it was deleted.Code:$query = "DELETE FROM WorkOrders WHERE id='$TicketNumber' AND siteid='$siteid'"; $result=mysql_query($query);




Reply With Quote