how can a varchar(14) be auto updated with another timestamp field?

vaaaska

This is driving me a little crazy...

I have a field that is a simple varchar(14). 14 obvious being for "YmdHis" date/time information. I only want this field to update when I tell it to update...

So, everytime I hit the database the udate field updates with now() automatically (it's a timestamp field). However, it's controlling the cdate field (explained above). No matter what I do I can't get a query to update this field - udate has control.

I've tested the query and it does work on other fields...but I've completely lost control of this cdate field. I don't understand how another field could do this...

This is how simple the query is...

$db->updateRecord("UPDATE ".TABLE." SET cdate = '' WHERE id = '$id'");

I could insert something between the quotes or use NULL but nothing will work...

Anybody seen this before? Have I designed my udate field improperly?

fean0r

Try this rename cdate to abcdate (for testing) - I know when I had this problem it was related to the field name.

Let me know if that helps.

vaaaska

Yeah, I've tried that...a few times...

It's also not the first timestamp column, so it shouldn't be auto-updating...

But I'm thinking this is a good reason to switch to a different time format...

0000-00-00 00:00:00

And then just use datetime instead of timestamp...it's my understanding that datetime doesn't behave this way...