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

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

2003-07-25 Thread Moreno Riccardi
MAIL PROTECTED] Inviato: venerdì 25 luglio 2003 17.39 A: Moreno Riccardi; [EMAIL PROTECTED] Oggetto: 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. - Original Message - From: "Moreno Riccardi" <[EMAIL P

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

2003-07-25 Thread CPT John W. Holmes
ROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, July 25, 2003 4:34 PM > Subject: R: [PHP-DB] MYSQL and PHP cast() function... > > > > Try > > $query2 = "select Title, date_format(Date,'%d-%m-%Y) as Date, Artist, > > Country, > > RecordCompany

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

2003-07-25 Thread Morgan Bardon
> -Messaggio originale- > Da: Morgan Bardon [mailto:[EMAIL PROTECTED] > Inviato: venerdì 25 luglio 2003 17.17 > A: [EMAIL PROTECTED] > Oggetto: [PHP-DB] MYSQL and PHP cast() function... > > > Hi there, > > I have been trying to get a solution to this select query

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

2003-07-25 Thread Moreno Riccardi
dì 25 luglio 2003 17.17 A: [EMAIL PROTECTED] Oggetto: [PHP-DB] MYSQL and PHP cast() function... Hi there, I have been trying to get a solution to this select query from all over the web and have found no answer so I was hoping someone here could help out. The date field of the database is impor

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

2003-07-25 Thread Morgan Bardon
Hi there, I have been trying to get a solution to this select query from all over the web and have found no answer so I was hoping someone here could help out. The date field of the database is imported from a text file with the date format 'dd-mm- hh:mm:ss' and I only want to display the fir