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` , `content_reference` ,
`language` , `ip_address` , `rating_timestamp` , `rating` ) VALUES ( NULL ,
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` ,
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