Forms problem with PHP/MySQL

Anon

Hi - First post; please excuse me if I'm not following any etiquette. I have searched through the forums and haven't been able to find any topic that is relevant.

Ok, I have a form that is to be used for insertion of rows into a MySQL database. I'm having trouble with one form field not being entered into the database correctly. It's a DATETIME element in the database and I load the form field's value automatically from within PHP with the correct value. The problem is, when it gets stored, all that is displayed when I examine my database is the default value for a DATETIME type (0000-00-00 00:00:00).

I don't know what I'm missing here. Does anyone have any suggestions they could offer?

TIA

Anon

If you're getting the 000000 then the data you're trying to insert either isn't there or is in a format the database can't understand. Echo the query before you execute it to see if the date is actually in the format you think it is.

Anon

I've done the echo bit. Data seems to be correct. I've stepped over every line of code in an attempt to figure it out but it is beyond me. ...

Anon

Ok - nevermind the last post. That data isn't even being sent to my function. My function looks at the $HTTP_POST_VARS to find the form values. It seems as though the information from the timestamp isn't being sent from the browser to the script.

All I want to do is load the data in a text field into the database. The data in the text field is loaded into a column of type DATETIME and is in the format "0000-00-00 00:00:00". Is this fine or should I change it all?

Anon

Got it figured out. I had the forms disabled so the user couldn't change the value. My workaround was to duplicate the data and store it in hidden input fields and it works. Geeze, sometimes you get so lazy you just don't look 😉