List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:August 3 1999 2:49pm
Subject:Re: update question
View as plain text  
PinkeshP@stripped wrote:
> I want to update a column called "viewed" every time that particular record
> was displayed in the query to keep track of how many times that record was
> displayed. What would be the efficient way to do this?
> -----------------------------------------
> Pinkesh N. Patel

Hi Pinkesh

Just do:
SELECT ID, value1, value2, ... FROM table WHERE ...
UPDATE table SET viewed = viewed + 1 WHERE ID = valueYouGotInTheSelect


update questionPinkeshP2 Aug
  • Re: update questionChristian Mack3 Aug