RE: [PHP-DB] UPDATE instead of INSERT INTO

http://dev.mysql.com/doc/refman/5.0/en/replace.html Or as previously mentined: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html -Original Message- From: Ron Piggott [mailto:ron@actsministries.org] Sent: Saturday, September 05, 2009 1:19 PM To:

Re: [PHP-DB] UPDATE instead of INSERT INTO

INSERT INTO ON DUPLICATE KEY UPDATE is what you're looking for. On 9/5/09, Ron Piggott ron@actsministries.org wrote: I made an application which lets users rate web site content. At the heart of the application is this mySQL query: INSERT INTO `ratings` ( `reference` , `content_type` ,

Re: [PHP-DB] UPDATE instead of INSERT INTO

Thanks - Original Message - From: Waynn Lue waynn...@gmail.com To: Ron Piggott ron@actsministries.org; php-db@lists.php.net Sent: Saturday, September 05, 2009 4:45 PM Subject: Re: [PHP-DB] UPDATE instead of INSERT INTO INSERT INTO ON DUPLICATE KEY UPDATE is what you're looking