I created a date field in an already existing MySQL table with
ALTER TABLE table_name ADD COLUMN session_date DATE;
Then I inserted today's date into this column with
<?php
$query="insert into table_name (group_id, session_date) values (1, " . date("m-d-Y", time()) . ")";
$result=mysq_query($query);
?>
but when I check the value of session_date, it displays 0000-00-00.
How do I enter the correct date into this field?
Thanks.
Amrit
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016
Please include the email address which you have been contacted with.