[SOLVED] formatting the date

[dazzclub]

Hi all,

 

i would like to display my date as day.month.year, ie (my birthday) 29.10.82

 

here is what i have got so far;

 

function InTheNews()
{
global $dbc;
$query = "SELECT id,title, content,date FROM news_headlines ORDER BY id";
$result = mysqli_query ($dbc, $query)or die(mysqli_error() . "<p>With query:<br>$query");
while ($row = mysqli_fetch_array($result))
//need to format the date on this function
$date = $row['date'];
{
//get NewsID 
echo "<div class=\"headline\">
           <a href=\"news_article.php?news_article=$row[id]\">$row[title]</a>
	   <span class=\"date_of_article\">".date("m.d.y","$date")."</p>
	   <p>$row[content]</p>
           </div>
        
";
}
}

 

Any help would be great

[Salkcin]

date("m.d.y", strtotime($date))

[dazzclub]

Thank you Salkcin