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 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.ger...@scl.utah.edu

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

[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);

???


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

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

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

???

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