note 20514 deleted from function.mysql-query by didou
| From: | didou@php.net | Date: | Sat, 16 Aug 2003 09:27:27 +0000 |
| Subject: | note 20514 deleted from function.mysql-query by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-54303@lists.php.net to get a copy of this message | ||
Note Submitter: webmaster@NOSPAMtrafficg.com
----
For doing update or insert code, its worth noting that Example 1 seems to be around 60% faster than
Example 2
********************
Example 1
********************
$rs = mysql_query("SELECT id FROM users WHERE name = 'pete'");
if($row = mysql_fetch_array($rs))
{
mysql_query("UPDATE users SET visits=visits+1 WHERE id =
'".$row["id"]."'");
}
else
{
mysql_query("INSERT INTO users (name) VALUES ('pete')");
}
********************
********************
Example 2
********************
$rs = mysql_query("UPDATE users SET visits=visits+1 WHERE name = 'pete'");
if(mysql_affected_rows() == 0)
{
mysql_query("INSERT INTO users (name) VALUES ('pete')");
}
********************
Pete Kelly