PHP Problems

Hello!

I need help in interfacing php with mysql.

I want to format a date using mysql's date_format function.

In telnet I typed the following and it works great:
select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-> 'Saturday October 1997'
But in php3 I typed the following and it does not work:

$open_db = MYSQL_CONNECT("localhost","blablabla");
MYSQL_SELECT_DB("a",$open_db);
$date_action = select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
$date_name = MYSQL_QUERY($date_action,$open_db);
echo $date_name;

What is wrong with this code?

I'm not sure if it's a typo, but you don't have quotes around your assignment of $date_action:

$date_action = "select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y')";

Also, after mysql_query(), $date_name would contain the result index, not the result. You still need to extract the data from the results. I.E.:

$result=mysql_query($date_action);
list($date_name)=mysql_fetch_row($result);
echo $date_name;

HTH