Displaying data from database in PHP, first and last name going into same column

Question

I'm trying to display members from my database using PHP, however the last name goes in with the first name and I'm not quite sure why... Could anyone point me in the right direction?

<?php
$mysql_db_hostname = "localhost";
$mysql_db_user = "alex";
$mysql_db_password="";
$mysql_db_database="gym";

$con = mysql_connect($mysql_db_hostname, $mysql_db_user, $mysql_db_password) or die("Could not connect database");

mysql_select_db($mysql_db_database, $con) or die("Could not select database");

$query = mysql_query("select * from users WHERE Category='Member'");

echo "<table border=1>
<tr>
<th>Users ID</th>
<th>First Name</th>
<th>Last Name</th>
</tr>";

while($row =mysql_fetch_assoc($query))
{
echo "<tr>";
echo "<td>" . $row['user_id']."<br>" . "</td>";
echo "<td>" . $row['First_Name']."<br>" . "</td";
echo "<td>" . $row['Last_Name']."<br>" . "</td";
echo "</tr>";
}

echo "</table";
?>

As all the answers have indicated, the td tags are not closed. But make sure to notice your table tag as well. — crthompson
– crthompson, Commented Mar 17, 2014 at 20:46

Rottingham · Accepted Answer · 2014-03-17 20:40:28Z

3

You aren't closing the tags. Syntax highlighter would show the error.

while($row =mysql_fetch_assoc($query))
{
    echo "<tr>";
    echo "<td>" . $row['user_id']."<br>" . "</td>";
    echo "<td>" . $row['First_Name']."<br>" . "</td"; <-----------
    echo "<td>" . $row['Last_Name']."<br>" . "</td"; <------------
    echo "</tr>";
}

answered Mar 17, 2014 at 20:40

Rottingham

2,6341 gold badge15 silver badges14 bronze badges

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

Comments

Fabio · Accepted Answer · 2014-03-17 20:40:43Z

0

You are not closing your <td> tags properly

echo "<td>" . $row['First_Name']."<br>" . "</td>";
                                             //^here
echo "<td>" . $row['Last_Name']."<br>" . "</td>";
                                             //^and here

So the output is all one cell with both variables printed inside

answered Mar 17, 2014 at 20:40

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

Comments

Manly · Accepted Answer · 2014-03-17 20:41:37Z

0

You forgot to close the td on your first name field.

Just change

</td

to

</td>

answered Mar 17, 2014 at 20:41

Manly

3793 silver badges18 bronze badges

Collectives™ on Stack Overflow

Displaying data from database in PHP, first and last name going into same column

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related