[RESOLVED] Date issues

ElphieFabalaFae

Okay, I'm using the following code to call something from my database:

<html>
 <head><title>Get data</title></head>
 <body>

<?php

$rs = @mysql_connect( "###", "###", "###" );

$rs = @mysql_select_db( "website" );

$sql = "select * from fan_reviews order by fan_reviews_id";

$rs = mysql_query( $sql );


while( $row = mysql_fetch_array( $rs ) )
{
?>

<span class="contentb">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="index2.php?id=fanreviews<?php echo $row["fan_reviews_id"]; ?>"><img src="images/folder_new.gif" width="21" height="20" align="top" border="0"></a> <?php echo $row["fan_reviews_date"]; ?></span> - <span class="content"><i><?php echo $row["fan_reviews_author"]; ?></i></span>


<?php } ?>

 </body>

</html>

The problem is because MySQL is storing the fan_reviews_date as yyyy-mm-dd, it's displaying content as 2006-09-12, whereas I need it to show 12th September 2006. I've been through my PHP/MySQL books and I can see how to create the date correctly within MySQL, and I've seen mention of the php date() function. I've tried entering various combinations on various parts of various pages, but I can't seem to get the right thing in the right place. I either get what I always have, 2006-09-12, or the page doesn't show at all! Can anyone help?

Installer

With MySQL:

SELECT *, DATE_FORMAT(fan_reviews_date, '%D %M %Y') AS formatted_date FROM fan_reviews ORDER BY fan_reviews_id

or with PHP:

$d = date('jS F Y', strtotime($row['fan_reviews_date']));

ElphieFabalaFae

Having applied the MySQL to the database, and the PHP to the script page, I finally have everything coming up as it should do! Thank you!