ngreenwood6 Posted July 31, 2008 Share Posted July 31, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/117620-solved-display-all-variables-in-mysql/ Share on other sites More sharing options...
trq Posted July 31, 2008 Share Posted July 31, 2008 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; } } Quote Link to comment https://forums.phpfreaks.com/topic/117620-solved-display-all-variables-in-mysql/#findComment-605007 Share on other sites More sharing options...
ngreenwood6 Posted July 31, 2008 Author Share Posted July 31, 2008 Thanks for your help! Quote Link to comment https://forums.phpfreaks.com/topic/117620-solved-display-all-variables-in-mysql/#findComment-605017 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.