Re: SQL statement
| From: | David Robley | Date: | Wed, 24 Sep 2003 06:57:44 +0000 |
| Subject: | Re: SQL statement | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-163696@lists.php.net to get a copy of this message | ||
In article <00ca01c3822e$d05406a0$f40d630a@compucom.local>,
drychlik@tcsconsult.com says...
> Hello,
>
> Im having a bit of trouble with the DATE_FORMAT function in mysql.
>
> $query = ('SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y') FROM
> custlogon');
>
> I know its failing because php doesnt like the quotation before the format parameters. Ive
> tried to fix this without any luck. Any Ideas ?
>
> DATE_FORMAT ( timestamp, ' %d%m%y ')
>
> Thanks in advance,
> -Dan
Try
$query = "SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y') FROM
custlogon";
--
Quod subigo farinam
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?