"; echo "\n"; echo "\n"; while($row=mysql_fetch_array($result)) { echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; echo"\n"; } echo"

Date	Header	Details	Spt?	Actions
".$row["NICEDATE"]."	".$row["events_header"]."	".substr($row["events_detail"],0,50)."...	"; if($row["sport"]==1) echo"Yes"; else echo"No"; echo"	Modify"; echo"\n Delete

"; } if(!($connection=@mysql_connect($hostName, $dbUsername, $dbPassword))) die("Could not connect to DB"); if(!(mysql_select_db ($databaseName, $connection))) showerror(); $listQuery="SELECT *,DATE_FORMAT(events_date, '%D %b %Y at %H:%i') AS NICEDATE FROM events ORDER BY events_date"; if(!($result = @mysql_query($listQuery,$connection))) showerror(); //print_r($result); listEvents($result); mysql_close($connection); include 'footer.php'; ?>