date format sql in php (changing the date)

[strafe]

Hi

I am making a simple database and ruse this php to show the events but want to change the date format here is my code - it shows all the information apart from the date which is blank ??? does anyone know why I am a bit stumped??

<?

include("connect.php");
$query="SELECT event_group_id,event_name,date_format(event_date,'%d/%m/%Y') FROM Events";

$sql=mysql_query("$query");
while( $results = mysql_fetch_object( $sql))
{

print "<tr>";
print "<td><span class=results_style11>$results->event_group_id</span></td>";
print "<td><span class=results_style11>$results->event_name</span></td>";
print "<td><span class=results_style11>$results->event_date</span></td>";

print "</tr>";
}

print "</table>";

?>

[NogDog]

Try using an alias in the SQL:

$query="SELECT `event_group_id`,`event_name`,date_format(`event_date`,'%d/%m/%Y') [color=red]AS`dmy`[/color] FROM Events";

Then in your PHP reference $results->dmy (instead of $results->event_date).

[strafe]

You are a legend been tearing my hair out with that!!

Thankyou