PHP Update query

[Ron Piggott (PHP)]

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

[chris smith-9]

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

[Yves Sucaet]

Hi Ron,

Have a look at http://www.php.net/manual/en/function.mysql-info.php

----- Original Message -----
From: "Ron Piggott" <ron.php@...>
To: "PHP DB" <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 = "UPDATE `clients` SET `company` = '$company', `contact` =
> '$contact', `phone` = '$phone', `city` = '$city' WHERE
> `clients`.`reference` =$client LIMIT 1";
> $client_result=mysql_query($query);
>
> ???
>
> Ron
>

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

[Sudheer Satyanarayana-4]

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.


--

With warm regards,
Sudheer. S
Tech stuff: http://techchorus.net
Business: http://binaryvibes.co.in


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

[Jason Gerfen-2]

$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.
>
>

--
Jason Gerfen
Systems Administration/Web application development
jason.gerfen@...

Marriott Library
Lab Systems PC
295 South 1500 East
Salt Lake City, Utah 84112-0806
Ext 5-9810


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

[David Robley-2]

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.


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