[PHP-DB] ON DUPLICATE KEY UPDATE

2010-11-27 Thread Ron Piggott
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`

Re: [PHP-DB] ON DUPLICATE KEY UPDATE

2010-11-27 Thread kesavan trichy rengarajan
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.pigg...@actsministries.org wrote: My question is with the syntax below: If the “ON DUPLICATE KEY UPDATE `name` = '$name'”