Re: PHP Update query

Jason Gerfen wrote: > $query = "UPDATE clients SET > company = '$company', > contact = > '$contact', phone = '$phone', > city = '$city' WHERE > clients.reference =$client > LIMIT 1"; > $client_result=mysql_query($query); > > // now check for errors > mysql_error() & mysql_errno() > > Sudheer Satyanarayana wrote: >> On Tuesday 03 November 2009 11:29 AM, 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); >>> >>> ??? >>> >>> Ron >>> >>> >> From the manual page: >> >> "For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, >> *mysql_query()* returns *TRUE* on success or *FALSE* on error. " >> >> If $client_result == true you know the query was successful. >> >> > > Those solutions will tell you if the query had no syntax errors. It won't tell you if any rows were updated. As was mentioned by others, the solution is mysql_affected_rows() which will "Get the number of affected rows by the last INSERT, UPDATE, REPLACE or DELETE query" Cheers -- David Robley Echo Trek: To boldly go off-topic where &#*@^$ NO CARRIER Today is Prickle-Prickle, the 17th day of The Aftermath in the YOLD 3175.