Date Format

[bravo14]

Hi all

I am trying to change the date format from my mysql database the format there is yyyymmdd, and the date I want to show them in is dd-mmm-yyyy

$result = mysql_query('SELECT * FROM `fixtures` ORDER BY `date`', $con) or die(mysql_error());
if(mysql_num_rows($result) < 1) 
{ 
   echo('<tr class="profiletext"><td colspan="7">Sorry, no results were found.</td></tr>'); 
} 
else 
{ 
   while($row = mysql_fetch_array($result))
    {
	if ($row[HomeAway]=="Home") {
	echo ('<tr><td>'.$row[Date].'</td><td><b>Yardley</b></td>');
	echo ('<td align="center">'.$row[yardley_goals].'-'.$row[opposition_goals].'</td><td>'.$row[Opposition].'</td>');
	echo ('<td></td><td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?match_id='.$row[match_id].'">View Fines</a></td></tr>');
       }

else{

echo ('<tr><td>'.$row[Date].'</td><td>'.$row[Opposition].'</td>');
echo ('<td align="center">'.$row[opposition_goals].'-'.$row[yardley_goals].'</td><td><b>Yardley</b></td>');
echo ('<td></td><td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?'.$row[match_id].'">View Fines<a></td></tr>');
    }
}
}
mysql_close($con);

Can anyone point me in the right direction as I am trying to teach myself PHP and MySQL

[Kudose]

-> [man]date[/man]
-> [man]strtotime[/man]

<?php
  $str = '20080315';
  echo date("m-d-Y", strtotime($str));
?>

[bradgrafelman]

Or, ditch the "SELECT *" (which I've always advocated against) and only SELECT the columns you actually need data from. Not only will this help save MySQL the trouble of sending data that you don't use, but you can also do what you're trying to accomplish:

SELECT col1, col2, DATE_FORMAT(`Date`, '%d-%b-%Y') AS `Date` FROM myTable