₦airaland Forum

Hello,

I been on this simple task to most of you for some hrs now, I am currently working on a small project and I have issues with formatting my date. I will be glad if someone can help.
Problem
I have a table called tblnews and I have newsid, contentbody, newsdate. Using while statement how do I display all the news selected from my database and most importantly format the date into dd/mm/yyyy not the default yyyy-mm-dd

$sql ="Select newsid, contentbody, DATE_FORMAT(newsdate, '%d/%m/%Y') as myNewsDate FROM tblnews";
$result = mysql_query($sql) or die("query error";
while( $row = mysql_fetch_array($result) )
{
echo "newsid=".$row['newsid'];
echo "contentbody".$row['contentbody'];
echo "myNewsDate".$row['myNewsDate'];
echo "
";

}

That should solve it but i expect you to change the code inside the while loop to something more suitable.

Pleas refer to http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format for more date formats.

Thanks Man, the code gave me what I needed