Select Date Help

[studgate]

I have the date in my database like yyyy/mm/dd (2000/01/01)

and I want to select it from the database as mm/dd/yyyy(01/01/2000)

the date column is "date_ur"

What I have is:

$sql_date = mysql_query("SELECT date_format(date_ur, '%M %D %Y') as date, COUNT(*) as num FROM table GROUP BY date  ORDER BY date") or die("Error in $strsql\n" . mysql_error());

I am not getting anything right now. What am I doing wrong??

Any help is welcome!

Thanks in advance

[.Darkman]

Try this :-

$sql_date = mysql_query("SELECT DATE_FORMAT(date_ur, '%M %D %Y') as date, COUNT(*) as num FROM table GROUP BY date  ORDER BY date") or die("Error in $strsql\n" . mysql_error());

[artacus]

Hint: Date is a reserved word... one that everyone likes to use as a column name

[.Darkman]

I think it can be used as Column. I do it and it works.

 

But i think it cannot be "SELECT as date"

 

Maybe change it to something.

[studgate]

I still didn't work, thanks though

 

[jcbarr]

I have run in to this before, you just have to make sure you put ` ` around it.

[studgate]

AROUND WHAT??

[jcbarr]

I was referring to using the word date, if you put `date` it will not treat it as a reserved word and you won't have those sorts of problems. Not sure if that will help you or not though...