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