[SOLVED] Display all variables in mysql

[ngreenwood6]

I am trying to display all of the variables under a table row. my code is:

 

<?php

//include the variables
include ("variables.php");
include ("db.php");

$getfrom_db = "SELECT email FROM users";

//connect to database
$mysqli_connect = mysqli_connect($host,$db_user,$db_pass,$db_name)
or die ("Could not connect to database");

//variable to get data to the database
$result = mysqli_query($mysqli_connect,$getfrom_db)
or die ("Error: ".mysqli_error($mysqli_connect));

//get the data and pull it
$info = mysqli_fetch_array($result);

//used for the connection to get email addresses from database
$email = $info['email'];

if (!$info)
{
echo ("No Data");
}
else
{
echo ("$email");


}
?>

 

The echo statement at the bottom is supposed  to display all of the emails but it is only displaying the first one in the database. Does anyone have any idea how to display more than one database object.

[trq]

You need a loop.

 

while ($info = mysqli_fetch_array($result)) {
  //used for the connection to get email addresses from database
  $email = $info['email'];
  if (!$info) {
    echo "No Data";
  } else {
    echo $email;
  }
}

[ngreenwood6]

Thanks for your help!