Displaying MySQL data in PHP Table Not working

Question

Currently I'm creating just a simple website that I'm fooling around with. Users can add movies to watch, and then can view them later on. What my current problem is, is this.

enter image description here

Sorry for the large image. As you can see its displaying the first result correctly, but the second result gets all skrewy and displays at the top of the screen. My code for displaying the data is:

$result = mysql_query("SELECT * FROM `movies`");

echo "
<table id=\"allTable\" align=\"center\" border=\"0\" cellpadding=\"4\" cellspacing=\"0\" width=\"100%\">
<tr>
<th>ID</th>
<th>Movie</th>
<th>Genre</th></tr>";

while($row = mysql_fetch_array($result)){
    echo "<tr>";
    echo "<td>" . $row['id'] . "</td>";
    echo "<td>" . $row['name'] . "</td>";
    echo "<td>" . $row['genre'] . "</td";
    echo "</tr><br />";
    echo "</table>";
}

Any help would be greatly appreciated!

EDIT Fixed the problem right after I created this. Removed from while loop and put it under. Fixed.

Paul Lo · Accepted Answer · 2013-11-22 19:32:15Z

1

echo "</table>"; should be moved outside of your while($row = mysql_fetch_array($result))

while($row = mysql_fetch_array($result)){
                echo "<tr>";
                echo "<td>" . $row['id'] . "</td>";
                echo "<td>" . $row['name'] . "</td>";
                echo "<td>" . $row['genre'] . "</td";
                echo "</tr><br />";

            }
echo "</table>";

answered Nov 22, 2013 at 19:32

Paul Lo

6,1466 gold badges33 silver badges37 bronze badges

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

1 Comment

mewm Over a year ago

True... Although you should consider looking at php.net/manual/en/book.pdo.php

Collectives™ on Stack Overflow

Displaying MySQL data in PHP Table Not working

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