How to I input my mysql database table into this list?

Question

I'm trying to input my mysql database into this html table without messing up the css, I've tried to do it as shown here with a table, but I can't get it to work.

http://www.w3schools.com/php/php_mysql_select.asp

The list should look like so..

Categories

Business
Computer Science
Economics
English
Engineering
Mathematics
Statistics
Student Success

Here is my code,

 <div class="col-md-2">  <!-- start left navigation rail column -->
         <div class="panel panel-info spaceabove">
            <div class="panel-heading"><h4>Categories</h4></div>
               <ul class="nav nav-pills nav-stacked">
                <?php
                    include "cs234DbConnect.inc.php";
                    $dbc =  mysqli_connect(DBHOST, DBUSER, DBPWD, DBNAME);
                    $error = mysqli_connect_error();
                    if(mysqli_connect_errno()){
                        echo "Failed to connect to MYSQL: " . mysqli_connect_error();
                    }
                    $result = mysqli_query($dbc, "SELECT CategoryName FROM site7_categories") or die(mysqli_error($dbc));
                    while($list = mysqli_fetch_array($result)){
                        echo "<li>" . $result['CategoryName'] . "</li>";
                    }
                    ?>

            </ul>
         </div>

MH2K9 · Accepted Answer · 2014-10-24 03:46:53Z

1

You should use $list['CategoryName'] instead of $result['CategoryName'].

while($list = mysqli_fetch_array($result)){
    echo "<li>" . $list['CategoryName'] . "</li>";
}

answered Oct 24, 2014 at 3:46

MH2K9

12.1k7 gold badges34 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

tonnor22 Over a year ago

Oh wow, simple mistake, how would I give each of those a dummy link if you don't mind? Thank you for pointing that out by the way.

Collectives™ on Stack Overflow

How to I input my mysql database table into this list?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related