PHP

php echo sql result

$sql = "select * FROM tableName;";

$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
  echo $row['columnName']; 
}

php echo sql result

$sql="SELECT * my_table"

$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
    echo $row['fieldname']; 
}