Ron Piggott wrote:
How do I test if an UPDATE query worked

$query = "UPDATE `clients` SET `company` = '$company', `contact` =
'$contact', `phone` = '$phone', `city` = '$city' WHERE
`clients`.`reference` =$client LIMIT 1";
$client_result=mysql_query($query);

???

http://www.php.net/manual/en/function.mysql-affected-rows.php

If it returns 0 that could mean:
- no row was originally found with that condition
or
- no update was performed (the data stayed the same)

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to