Dan J. Rychlik <mailto:[EMAIL PROTECTED]>
on Tuesday, September 23, 2003 4:58 PM said:
> I know its failing because php doesnt like the quotation before the
> format parameters. Ive tried to fix this without any luck. Any
> Ideas ?
It's failing because the ' before the %d is closing the string.
Here's how I work out SQL stuffs:
$sql = "SELECT username\n"
." , password\n"
." , DATE_FORMAT(timestamp, '%d%m%y')\n"
."FROM custlogon";
$query = ($sql);
Althought it looks like it takes a lot more time to write (which is
true) it looks great when you are debugging.
echo "<pre>$sql</pre>";
Alternatively you should be able to do this:
$query = ("SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y')
FROM custlogon");
chris.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
