inserting a timestamp

From: Date: Thu, 19 Apr 2001 05:12:47 +0000
Subject: inserting a timestamp
Groups: php.db 
Request: Send a blank email to php-db+get-8682@lists.php.net to get a copy of this message
hey all, I am having a hell of a time getting a timestamp to insert correctly. it keeps coming up 00000000000000 here's what i have $date_avail = mktime (0,0,0,$month,$day,$year); $avail = date("F j, Y", $date_avail); echo "Date Available: $avail"; this works fine and displays the date correctly My insert statement is fine [no mistakes] I insert $date_avail into the date_avail field which is type TIMESTAMP - when i inserti get a 0000000000000 If i change the field type of date_avail to VARCHAR it inserts correctly and i can reference it as a timestamp and display correctly [a mysql db] can anyone help, i guess that using varchar is fine, but i have wasted a half a day and am a little pissed about this. I noticed that even when i try to change the date_avail field with phpmyadmin to NOT NULL it changes to NULL - i think that this is the prob, but i do not know thanks much olinux

« previous php.db (#8682) next »