$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
}