In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] 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?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
