how to pass DATE_FORMAT to mySQL

[Anon]

Hi guys...

I have a problem:

I get a syntax error when passing the following to mySQL

$query="select DATE_FORMAT(sDate,"%m %d %Y") from status";

if i take out the DATE_FORMAT() function, it works fine..
how can i pass a funcntion through the php string? magic quote?

as usual..your help is greatly appreciated 🙂

[[deleted]]

Well how is PHP supposed to figure out what the string looks like
it you have four quotes in it?
To PHP, this:
$query = "select DATE_FORMAT(sDate,"%m %d %Y") from status"

looks like
$query = "select DATE_FORMAT(sDate,"
%m %d %Y
") from status"

And that % doesn't make any sence in PHP.

Try using single quotes inside double quotes, or escape the double quotes when you mean them to be really double quotes, and not string delimiters.

$query = "select DATE_FORMAT(sDate,'%m %d %Y') from status"
$query = "select DATE_FORMAT(sDate,\"%m %d %Y\") from status"

[Anon]

thanks man..
i know i am dumb..that is why this great form is here to rescue people like us 🙂

[[deleted]]

giggle