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: php-db@lists.php.net > > Subject: [PHP-DB] UPDATE instead of INSERT INTO > > > > 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 , > > '$content_type','$content_reference' , '$language', > > '$ip_address', NOW( ) , '$user_rating' ); > > > > I am wondering if there is a way to check if the user has > > already voted (IE If there is already a matching record with > > the same content_type, content_reference, language, > > ip_address values) so all that happens is an UPDATE to the > > rating field? > > > > Ron
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php