Formating date from mySql query

[shill]

I’m trying to format the date from my query. Here’s what I’ve got so far.

[code]if ($r = mysql_query ($query)) {

    while ($row = mysql_fetch_array ($r)) {
        print "<tr><td>{$row['show_date']}</td>
        <td>{$row['show_city']}, {$row['show_state']} {$row['show_country']}</td>
        <td>{$row['show_venue']}</td>
        \n";
    }[/code]

I think I may need something like this but I’m not sure.

[code]$show_date = date("m.d.y");[/code]

Thanks for any help.

[wildteen88]

You'll want to do something like this:
[code]$date = date("d.m.y" , strtotime($row['show_date']))[/code]