Re: [PHP-DB] MYSQL and PHP cast() function...

2003-07-25 Thread Morgan Bardon
ot; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 4:44 PM Subject: Re: [PHP-DB] MYSQL and PHP cast() function... > > Thanks for that, but I get a NULL entry in the field then for all the > dates. > > What column type is the DATE column? Also, si

Re: [PHP-DB] MYSQL and PHP cast() function...

2003-07-25 Thread CPT John W. Holmes
> Thanks for that, but I get a NULL entry in the field then for all the dates. What column type is the DATE column? Also, since DATE is a reserved word in MySQL, naming a column DATE probably wasn't a good idea. If you know you always want the first 11 characters, you can always do LEFT(Date,11) t

Re: [PHP-DB] MYSQL and PHP cast() function...

2003-07-25 Thread Morgan Bardon
Thanks for that, but I get a NULL entry in the field then for all the dates. - Original Message - From: "Moreno Riccardi" <[EMAIL PROTECTED]> To: "Morgan Bardon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 4:34 PM Subject: R: [PHP-DB] MYSQL and PHP cast() function