number of affected rows code example
Example: mysqli check if delete was successful
$sql = "DELETE FROM art WHERE id='5'";
if($db->query($sql)=== TRUE) {
$message = "good"; // all worked good.
}else{
$message = "bad"; // didnt work because something was wrong
}