Display mysql data

[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.

[MatthewJ]

do {

echo $info['email'];

} while ($info = mysqli_fetch_array($result));

[ngreenwood6]

wow that was great. worked like a charm. now i have one more question for you if you could. it displays them both on the same line. I would like to add a <br> in between. how would i go about doing that?

[MatthewJ]

do {

echo $info['email']."<br />";

} while ($info = mysqli_fetch_array($result));

 

Glad I could help

[ngreenwood6]

That worked as well. You are now 2 for 2.  if you dont mind (sorry noob trying to figure this out) what about if the code looked like this:

 

do {

echo $info['email'], $info['var'];

} while ($info = mysqli_fetch_array($result));

 

How would I do the "</br>" then, and also how would i put it in front of the first $info['email'] to move that down a line? Any help is appreciated.

[akitchin]

this is simple variable and string concatenation.  search online for it, and a tutorial should give you a good handle on it:

 

while ($info = mysqli_fetch_array($result))
{
  echo 'E-mail address: '.$info['email'].'<br />';
  echo 'Variable: '.$info['var'].'<br />';
}

[ngreenwood6]

thanks now that is what i wanted. you guys are great and this is a great community. thanks for all your help guys