Re: [PHP-DB] PHP Update query

2009-11-04 Thread Jason Gerfen
$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

[PHP-DB] PHP Update query

2009-11-02 Thread Ron Piggott
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

Re: [PHP-DB] PHP Update query

2009-11-02 Thread Chris
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); ???

Re: [PHP-DB] PHP Update query

2009-11-02 Thread Yves Sucaet
Hi Ron, Have a look at http://www.php.net/manual/en/function.mysql-info.php - Original Message - From: Ron Piggott ron@actsministries.org To: PHP DB php-db@lists.php.net Sent: Monday, November 02, 2009 11:59 PM Subject: [PHP-DB] PHP Update query How do I test if an UPDATE query

Re: [PHP-DB] PHP Update query

2009-11-02 Thread Sudheer Satyanarayana
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);