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