$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
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
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);
???
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
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);