[RESOLVED] displaying DATE_FORMAT()

[drew_man]

I have mysql field name, date, set to "date" and in my INSERT query I am using the now() fuction to capture the date it was posted. I can SELECT the date and displays in "yyyy-mm-dd" format, which worked fine until I tried changing the format using the DATE_FORMAT() function, and now nothing for the date displays on the page. Below is the code I am using to select the info:

include ("includes/db_connect.php");
	$result = mysql_query("SELECT title, author, joke_body, DATE_FORMAT(date, '%d-%m-%Y') FROM jokes ORDER BY jokes_id DESC LIMIT 3");
mysql_close($db_connect);
	while($row = mysql_fetch_array($result)){
		$title = htmlentities ($row['title']);
		$author = htmlentities ($row['author']);
		$joke_body = nl2br ($row['joke_body']);
		$date = htmlentities ($row['date']);
			echo "$date";
}

Can anyone see what my problem may be? Thanks.

[bpat1434]

Date is a reserved word I believe.... try changing the column name to something different, or using this:

$result = mysql_query("SELECT title, author, joke_body, DATE_FORMAT(`Date`, '%d-%m-%Y') FROM jokes . . . ");

Note: The "quotes" around the date column name are actually back-ticks (same key as the tilde, next to the "1" key) and not quotes.

[drew_man]

Thank you for your help. I tried both suggestions and neither worked.
My original code looked like this:

include ("includes/db_connect.php");
	$result = mysql_query("SELECT * FROM jokes ORDER BY jokes_id DESC LIMIT 3");
mysql_close($db_connect);
	while($row = mysql_fetch_array($result)){
		$title = htmlentities ($row['title']);
		$author = htmlentities ($row['author']);
		$joke_body = nl2br ($row['joke_body']);
		$date = htmlentities ($row['date']);
			echo "$date";
}

and it displayed "yyyy-mm-dd"

Now my code is:

include ("includes/db_connect.php");
	$result = mysql_query("SELECT title, author, joke_body, DATE_FORMAT(post_date, '%d-%m-%Y') FROM jokes ORDER BY jokes_id DESC LIMIT 3");
mysql_close($db_connect);
	while($row = mysql_fetch_array($result)){
		$title = htmlentities ($row['title']);
		$author = htmlentities ($row['author']);
		$joke_body = nl2br ($row['joke_body']);
		$date = htmlentities ($row['post_date']);
			echo "$date";
}

and displays nothing. Could there be something I'm missing when I create the $date variable, do I need to add anything to it since I'm now using the DATE_FORMAT()?

Thanks

[bpat1434]

alias it....

SELECT title, author, joke_body, DATE_FORMAT(post_date, '%d-%m-%Y') as dated FROM jokes ORDER BY jokes_id DESC LIMIT 3

$date = $row['dated'];

[drew_man]

Thank you so much, that did the trick!