Not sure, I ran this query in myphpadmin query window: SELECT * , DATE_FORMAT( ship_date, '%d/%M/%Y' ) AS test_date FROM coop_item WHERE warehouse = 'N' LIMIT 50
And it works fine. Do you have phpMyAdmin installed and you can play with the select statement there before putting it in to php. Pat www.gypsyfarm.com -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of kab62uk Sent: Friday, February 17, 2006 2:36 PM To: [email protected] Subject: [php_mysql] Trying to date format and use where statement Hi I am trying to combine the following two queries into one. I have tried all sorts and cant get it to work can anyone advise me? $query_Recordset1 = sprintf("SELECT * FROM CC_Courses WHERE Course_Category = '%s'", $colname_Recordset1); $query_Recordset1 = "SELECT *,DATE_FORMAT(thedate,'%d/%M/%Y') as fdate FROM CC_Courses"; Thank you in advance M The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
