INSERT INTO ON DUPLICATE KEY UPDATE is what you're looking for. On 9/5/09, Ron Piggott <ron.php@xxxxxxxxxxxxxxxxxx> 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` , `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
