Re: [PHP-DB] Storing Date in mysql

2004-07-08 Thread Michael Gale
Thanks ... I can't believe I missed that in the docs ... now I feel like knob. Michael. On Thu, 8 Jul 2004 14:17:38 -0300 "Pablo M. Rivas" <[EMAIL PROTECTED]> wrote: > Hello Michael, > token_date must be a DATE FIELD... > > http://dev.mysql.com/doc/mysql/en/Column_types.html > >

Re: [PHP-DB] Storing Date in mysql

2004-07-08 Thread Pablo M. Rivas
Hello Michael, token_date must be a DATE FIELD... http://dev.mysql.com/doc/mysql/en/Column_types.html MG> Hello, MG> I need to store the date of record / entry in the mysql database, so I have the following table create statement: MG> CREATE TABLE `token_table` ( MG> `to

[PHP-DB] Storing Date in mysql

2004-07-08 Thread Michael Gale
Hello, I need to store the date of record / entry in the mysql database, so I have the following table create statement: CREATE TABLE `token_table` ( `token_id` int(11) NOT NULL auto_increment, `token_utuser_id` int(11) NOT NULL default '0', `token_name` varchar(100) NOT NULL defau