I'm running some UPDATE/DELETE x WHERE x=y type queries on my db from php. Is there a way to find out if the delete was succesful or if there was some kind of error i.e there were no instances of x=y in the table.
Take a look at [man]mysql_affected_rows/man