Hi
I am making a simple database and trying to format the date within the sql query, all the information is showing fine apart from the date field. i have tested the sql and it runs fine but showing it in php does not work and leaves it blank??
<?
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>";
?>
Does anyone know the answer why it is not showing??
thankyou in advance
