UPDATE instead of INSERT INTO
| From: | Ron Piggott | Date: | Sat, 05 Sep 2009 20:19:25 +0000 |
| Subject: | UPDATE instead of INSERT INTO | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-46470@lists.php.net to get a copy of this message | ||
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