On 13 Jul 2006 at 8:27, wizard007 wrote: > I used $query_Recordset1 = "SELECT date_format(Date, "%d/%m/%Y") as Date, > Course, Time, Horse, Odds1, Odds2, `Result` FROM Results";
Hi, That's a PHP error because you have a double quotes: "%d/%m/%Y" within double quotes: $query_Recordset1 = "SELECT ...... .....FROM Results"; You need to escape the quotes in your statement. Regards Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]