$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
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);
Hi Ron,
Have a look at http://www.php.net/manual/en/function.mysql-info.php
- Original Message -
From: "Ron Piggott"
To: "PHP DB"
Sent: Monday, November 02, 2009 11:59 PM
Subject: [PHP-DB] PHP Update query
How do I test if an UPDATE query worked
$query = &
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/fu
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
