> try this: > > $query = "SELECT username, password, > DATE_FORMAT(CURRENT_TIMESTAMP(), '%d%m%y') FROM custlogon"; > > or if that doesnt work try: > > $query = "SELECT username, password, DATE_FORMAT(NOW(), '%d%m%y') > FROM custlogon"; [snip] original query as posted: SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y') FROM custlogon [/snip]
Unless timestamp is actually the name of a column in the database, in that case NOW() and CURRENT_TIMESTAMP() won't give the expected results. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php