----- Original Message ----- From: "Waynn Lue" <>
To: "Ron Piggott" <>; <>
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 for.

On 9/5/09, Ron Piggott <> 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?



No virus found in this incoming message.
Checked by AVG -
Version: 8.5.409 / Virus Database: 270.13.78/2347 - Release Date: 09/05/09 05:51:00

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to