Help with displaying SQL in HTML

[aaron4osu]

I'm trying to display customer info from sql database and I keep getting this error when the page loads.

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/haas12/public_html/somerset/admin.php on line 28

line 28 is: while ($row = mysqli_fetch_array($data))

<?php

  require_once('config_personal.php');

  // Connect to the database 
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 

  // Retrieve records from MySQL
  $query = "SELECT * FROM somerset_cust";
  $data = mysqli_query($dbc, $query);

  // Loop through the array of customer data, formatting it as HTML 
  echo '<table>';
  $i = 0;
  while ($row = mysqli_fetch_array($data)) { 
    // Display records
    if ($i == 0) {

  echo '<tr><th>Facility Name</th> <th>First Name</th> <th>Last Name</th> <th>Phone</th> <th>Email</th> <th>URL</th> </tr>';


}
echo '<tr><td>'. $row['facname'] . '</td>';
echo '<tr><td>'. $row['fname'] . '</td>';
echo '<tr><td>'. $row['lname'] . '</td>';
echo '<tr><td>'. $row['phone'] . '</td>';
echo '<tr><td>'. $row['email'] . '</td>';
echo '<tr><td>'. $row['url'] . '</td></tr>';

$i++;
  }
  echo '</table>';

  mysqli_close($dbc);
?>

Thanks-Aaron

[Weedpacket]

It means the result of [man]mysqli_query[/man] was false instead of a result set; this means that the query failed. With such a simple query there's not a lot to go wrong, but you should check that the database really does have a table named "somerset_cust" to select from.

[aaron4osu]

Thanks. I was missing the database name in front of the table name.

[sneakyimp]

You should always check the result of a query before trying to do anything with it. If it failed, you might want to show an error to the user or write a log or send yourself an email or something.

[PutsDrusa]

VigRX Together with 5 Month Up Virile Enhancemnt Penis Enlargement Pills Brobdingnagian Cache, Set-up Age! It is justifiably an dazzling Sale VigRX Added 5 Month Give Masculine Enhancemnt Penis Enlargement Pills.I highly recommend Rummage sale VigRX Extra 5 Month Afford Manful Enhancemnt Penis Enlargement Pills in place of anyone.I absolutly love it!

We Compare and Determine Muffled Prices to tender You Here! Worst Offers Today!

For men who longing bigger, harder, longer-lasting erections, there's now VigRX Plus. VigRX Bonus is the penis enhancement offshoot that delivers the most results in the shortest time. You'll be experiencing a larger penis when you're aroused, with greater erection content and longer-lasting animal performance.

Month #1: The initial exchange that you can expect to enjoy is longer enduring erections. TVigRX Increased by 5 Month Provisioning Spear Enhancemnt Penis Enlargement Pills Do not Miss!! After men who want bigger, harder, longer-lasting erections, there's now VigRX Plus. VigRX Profit is the penis enhancement product that delivers the most results in the shortest time. You'll prepare a larger penis when you're aroused, with greater erection intelligence and longer-lasting bodily performance.

Month #1: The blue ribbon mutation that you can expect to fancy is longer eternal erections. T... VigRX Plus 5 Month Rig out Male Enhancemnt Penis Enlargement Pills Study More

Coerce Less And Save More,Do not Dodge Our A-one Administer

More Details & Buy In this day!

Cheapest Evaluation VigRX Plus 5 Month Supply Spear Enhancemnt Penis Enlargement Pills

Most skilfully Get VigRX Added 5 Month Equip Spear Enhancemnt Penis Enlargement Pills

On Trade VigRX Bonus 5 Month Gear up Manful Enhancemnt Penis Enlargement Pills

Reduce VigRX Added 5 Month Come up with Manly Enhancemnt Penis Enlargement Pills

[PutsDrusa]

VigRX Gain 5 Month Afford Man's Enhancemnt Penis Enlargement Pills Massive Providence, Importance Age! It is really an awesome Mark-down VigRX Plus 5 Month Give Manful Enhancemnt Penis Enlargement Pills.I highly subscribe to Transaction VigRX Extra 5 Month Stock Masculine Enhancemnt Penis Enlargement Pills for anyone.I absolutly sympathy it!

We Look like and Determine Low Prices to provide You Here! A- Offers Today!

Allowing for regarding men who want bigger, harder, longer-lasting erections, there's now VigRX Plus. VigRX Increased by is the penis enhancement work that delivers the most results in the shortest time. You'll be suffering with a larger penis when you're aroused, with greater erection space and longer-lasting animal performance.

Month #1: The blue ribbon exchange that you can expect to take to is longer everlasting erections. TVigRX And 5 Month Supply Spear Enhancemnt Penis Enlargement Pills Do not Maiden!! For men who fancy bigger, harder, longer-lasting erections, there's stylish VigRX Plus. VigRX Increased by is the penis enhancement by-product that delivers the most results in the shortest time. You'll be suffering with a larger penis when you're aroused, with greater erection right stuff and longer-lasting sexual performance.

Month #1: The blue ribbon change that you can watch to the time of one's life is longer everlasting erections. T... VigRX Plus 5 Month Purvey Male Enhancemnt Penis Enlargement Pills Study More

High-pressure Less And Prevent More,Do not Miss Our Best Administer

More Details & Allow In this day!

Cheapest Expense VigRX Together with 5 Month Supply Man's Enhancemnt Penis Enlargement Pills

Nicest Get VigRX Plus 5 Month Equip Spear Enhancemnt Penis Enlargement Pills

On Sale VigRX Plus 5 Month Victual Male Enhancemnt Penis Enlargement Pills

Disregard VigRX Supplementary 5 Month Come up with Male Enhancemnt Penis Enlargement Pills