[RESOLVED] update a date field

[scambro]

Hi,

This seems like a very simple question, but I searched for quite a while and couldn't find the most basic update syntax. I have a field called date in a table, with a field type of DATE in mysql. I'm trying this in PHP, but I keep getting an error about the syntax:

UPDATE INTO table SET date = 01-01-1901 WHERE table_id = 1

I tried different date formats, yyyy-mm-dd and dd-mm-yyyy and it keeps rejecting my syntax. What do I have wrong? If someone could point me towards a basic updating a date thread, that would be perfect too!

Thanks!

[goldlikesnow]

UPDATE table SET date = '2006-01-01' WHERE table_id = 1

[scambro]

goldlikesnow wrote:

UPDATE table SET date = '2006-01-01' WHERE table_id = 1

Ah! All that time troubleshooting the date, and I had an extra flipping word.... 🙂

Thanks!