Re: Date Problems

2006-07-13 Thread Ian
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 = "SELEC

Re: Date Problems

2006-07-13 Thread wizard007
Hi, Just tried the date format script posted but it returns the following error: Parse error: parse error, unexpected '%' in /homepages/7/d123417448/htdocs/PayGo/results_14days.php on line 33 I used $query_Recordset1 = "SELECT date_format(Date, "%d/%m/%Y") as Date, Course, Time, Horse, Odds1, Od

Re: Date Problems

2006-07-13 Thread Jo�o C�ndido de Souza Neto
I put one select on each question. "wizard007" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > > I have just started with MYSQL and am building a racing site using PHP. > > I have Date, Course, Time, Horse, Odds, Result as my fields and the > database > is poulated with the dat