ON DUPLICATE KEY UPDATE
| From: | Ron Piggott | Date: | Sun, 28 Nov 2010 01:40:45 +0000 |
| Subject: | ON DUPLICATE KEY UPDATE | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47509@lists.php.net to get a copy of this message | ||
My question is with the syntax below: If the “ON DUPLICATE KEY UPDATE
name =
'$name'” occurs will $_SESSION['referral_clients_reference'] be populated with
the mysql_insert_id() value? If not, should I just query for it? Ron
mysql_query("INSERT INTO referral_clients ( reference ,
name , paypal_email , last_update ) VALUES ( NULL ,
'$name', '$paypal_email', CURRENT_TIMESTAMP ) ON DUPLICATE KEY UPDATE
name = '$name';");
$_SESSION['referral_clients_reference'] = mysql_insert_id();
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info