MySQL records not displaying within HTML table

Question

I've worked my way through this Youtube tutorial: https://www.youtube.com/watch?v=1YbbUS_SxSk&t=609s

..and for some reason, my data from my mySQL table is not printing at all within the table, though there appears to be the correct number of rows within the HTML table. Connection to MySQL and connection with the appropriate table seems to be working fine - the records are just not printing in the table.

> <html>
    <head>
        <title>Delete Records</title>
    </head>
    <body>
        <table border=1 cellpadding=1 cellspacing=1>
            <tr>
                <th>Image</th>
                <th>Delete</th>
            </tr>
            <?php
                //connect with mysql
                $con = mysqli_connect('localhost', 'root', '');
                if (!$con){
                    echo"Connection not established";
                }
                //select database
                mysqli_select_db($con, 'photos');

                //select query
                $sql = "SELECT * FROM images";
                if(!$sql){
                    echo"Table not selected";
                }

                //execute the query
                $records = mysqli_query($con, $sql);

                while (mysqli_fetch_array($records)){
                    echo "<tr>";
                    echo "<td>".$row['image']."</td>";
                    echo "<td><a href=delete.php?id=".$row['ID'].">Delete</a></td>";
                    echo "</tr>";
                }
            ?>
        </table>
    </body>
</html>

This is what the table ends up looking like: HTML Table

No data in the table!

supajason · Accepted Answer · 2017-05-07 17:32:43Z

2

Change this line

            while (mysqli_fetch_array($records)){

To

            while ($row = mysqli_fetch_array($records)){

answered May 7, 2017 at 17:32

supajason

6704 silver badges13 bronze badges

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

Comments

Young Starters · Accepted Answer · 2017-05-07 18:05:36Z

0

Simple error

 while ($row = mysqli_fetch_array($records))

This should be used to allow free flowing code

answered May 7, 2017 at 18:05

Young Starters

11 bronze badge

Collectives™ on Stack Overflow

MySQL records not displaying within HTML table

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related