real_escape_string($district).'" and chno!="" order by chno'; //echo $databaseQuery; $result1 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error()); //echo $result1; while($row = mysqli_fetch_array($result1)) { $appno=trim($row["appno"]); $chno=trim($row["chno"]); $sname=trim($row["sname"]); $club=trim($row["club"]); $agegroup=trim($row["agegroup"]); $gender=trim($row["gender"]); $skatertype=trim($row["skatertype"]); echo "

".$eventtitle."

".$chno."

".$sname."

".$agegroup." ".$gender." ".$club." ".$skatertype."

"; } ?>