<?include "conninfo.php";



$query="SELECT * FROM events WHERE eventdate>NOW() ORDER BY eventdate";
$result=mysqli_query($link,$query);

while($r=mysqli_fetch_array($result))
{
	
	echo $r["eventname"];
	echo " ";
	$et=$r["eventdate"];//drop into local variable
	$et=strtotime($et);//convert back to timestamp
	echo date('dS M Y',$et);//my preferred date format
	echo "<br>";
		
}