Read through this: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html, especially the last 2 paragraphs. On Sun, Nov 28, 2010 at 12:40 PM, Ron Piggott < ron.piggott@xxxxxxxxxxxxxxxxxx> wrote: > 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
