[PHP] PHP to MySQL and Date field

2001-10-30 Thread Jason
Here is my problem once again... =P I am wondering if I should change the date table to something other than date... maybe something like date_1? Would doing that resolve my issue, because of the fact that the date variable in php is function? Thanks in advance... Jason /* Form to supply

Re: [PHP] php or Mysql for DATE?

2001-03-15 Thread Tiki
You can also use the curdate() function in the MYSQL syntax. e.g. insert into table (datefield) values (curdate()); Cheers Kee Yong -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the

[PHP] php or Mysql for DATE?

2001-03-14 Thread Dhaval Desai
I want to have a posting column wherein people can post their messages and when a new message is posted the Curent date has to be added in the mysql database. Do u think I should use Php to generate the date or should I have mysql to generate the date. I am also going to allow people to search

RE: [PHP] php or Mysql for DATE?

2001-03-14 Thread David Smith
Try using ? $date = date ("Y-m-d H:i:s"); ? which formats the same as MySQL... -Original Message- From: Dhaval Desai [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 15, 2001 2:19 AM To: [EMAIL PROTECTED] Subject: [PHP] php or Mysql for DATE? I want to have a posting colu

Re: [PHP] php or Mysql for DATE?

2001-03-14 Thread David Robley
On Thu, 15 Mar 2001 17:49, Dhaval Desai wrote: I want to have a posting column wherein people can post their messages and when a new message is posted the Curent date has to be added in the mysql database. Do u think I should use Php to generate the date or should I have mysql to generate