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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



There's a mistake try this:

 $query2 = "select Title, date_format(Date,'%d-%m-%Y') as fDate, Artist,
 Country,
 RecordCompany, CatalogueNumber, Composer FROM recording where title regexp
 '$keyword'";
-----Messaggio originale-----
Da: Morgan Bardon [mailto:mbardon@comms-online.com]
Inviato: venerdì 25 luglio 2003 17.39
A: Moreno Riccardi; php-db@lists.php.net
Oggetto: Re:  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" <m.riccardi@webtrade.it>
To: "Morgan Bardon" <mbardon@comms-online.com>; <php-db@lists.php.net>
Sent: Friday, July 25, 2003 4:34 PM
Subject: R:  MYSQL and PHP cast() function...


> Try
> $query2 = "select Title, date_format(Date,'%d-%m-%Y) as Date, Artist,
> Country,
> RecordCompany, CatalogueNumber, Composer FROM recording where title regexp
> '$keyword'";
>
> Hi,
> Moreno
> -----Messaggio originale-----
> Da: Morgan Bardon [mailto:mbardon@comms-online.com]
> Inviato: venerdì 25 luglio 2003 17.17
> A: php-db@lists.php.net
> Oggetto:  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 imported from a text file with the date
> format 'dd-mm-yyyy hh:mm:ss' and I only want to display the first 11
> characters of the field.
>
> The select statment is am using is
> $query2 = "select Title, cast(Date as varchar(11)) Date, Artist, Country,
> RecordCompany, CatalogueNumber, Composer FROM recording where title regexp
> '$keyword'";
>
> However when I try to use this I get an error about the cast function as
> follows:
>
> You have an error in your SQL syntax near '(Date as varchar(11)) Date,
> Artist, Country, RecordCompany, CatalogueNumber, Com' at line 1
>
> Can anyone help me with the cast() function. I have gotten this to work on
> an internal MSSQL server but not on the MySQL server.
>
> thanks
>
> Morgan Bardon
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux