[SOLVED] Inserting date into specific row

[rachelk]

I have the columns 'id' and 'date' in the same table where the id column is already filled out like this:

 

id      date

---    ----

1

2

3

4

5

 

 

I was wondering how I could insert the current date into a row of a specified id?

 

Would it be something like this?

 

INSERT INTO $table_name (date) VALUE (NOW()) WHERE ID=$id

 

 

There are other filled out columns in the table as well if that makes a difference to this.. I'm doing this in an attempt to show only the id's that were clicked on in the past 24 hours, I thought I'd have to insert a date column to the existing table in order to make that happen..

 

Thanks in advance for any help!

 

[smerny]

UPDATE $table_name SET date=NOW() WHERE ID=$id

[rachelk]

Thank you!