I'm using PHP to add records into a mysql database. The records write
successfully to the database
except for the timestamp field which I have defined as
Field Type Null Key
Default Extra
TheDate timestamp(14) YES NULL
Everytime I write a record or edit a record it puts 000000000000000 in
the TheDate, which of course is not the correct date.
Here is the insert command below that I'm using, does anyone have a
solution.
$query3 = "INSERT INTO Quser VALUES('', '$fullname', '$add_novell',
'$tot_novell', '$add_cwis', '$tot_cwis', '$add_mail', '$tot_mail',
'TIMESTAMP')";
mysql_query($query3);
is the TIMESTAMP option where I get the current date from.
--
#########################################
Kory Wheatley
Academic Computing Analyst Sr.
Phone 282-3874
#########################################
Everything must point to him.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php