CODE EXAMPLE FOR PHP

display rows brought back by query php

$result = mysqli_query($sql); // execute query

// process each row returned from query
while($row = mysqli_fetch_array($result)) {
    echo $row['fieldname'];  // print the field (column name in table)
  	echo print_r($row);		 // print out the whole road
}