How to display MySql DATE in a better looking way?

[Guest]

Hi guys,

 

I would like to display on my webpage a DATE item from one of my database using PHP, but I would like to format it like "15 December 2009" instead of 2009-12-15.

 

Can anyone help me?

 

Thanks in advance for your help.

 

Cheers,

 

Chris

[PFMaBiSmAd]

Use the mysql DATE_FORMAT() function directly in your query to get a DATE into any format you want - http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

[Guest]

I tried that but apparently not well as I don't get anything. Here is what I tried:

 

<?php
$sql = "SELECT DATE_FORMAT(event_start_date,'%d %b %y') as event_start_date FROM events WHERE id = '2'";
$result = mysql_query($sql);
echo $result;
?>

 

Any idea what I did wrong?

[eugene2009]

Yes, theres a few errors that I spot. May I please see your full code?

[akitchin]

are you trying to actually echo the results? if so, you'll need to use a MySQL fetching function to extract the results from the resource ID mysql_query() returns.

[Guest]

Thanks a lot, it works fine now...