Re: UPDATE instead of INSERT INTO
| From: | Waynn Lue | Date: | Sat, 05 Sep 2009 20:45:52 +0000 |
| Subject: | Re: UPDATE instead of INSERT INTO | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46471@lists.php.net to get a copy of this message | ||
INSERT INTO ON DUPLICATE KEY UPDATE is what you're looking for.
On 9/5/09, Ron Piggott <ron.php@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 , 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
>