Display Results in Table

[macbb1117]

I am trying to get the values from a mysql query to display in a table within PHP.

I used this from W3School:

---

echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['FirstName'] . "</td>";
echo "<td>" . $row['LastName'] . "</td>";
echo "</tr>";
}
echo "</table>";

Which looks like this.

Heading 1 | Heading 2 | Heading 3
_______________________________________

Value 1 | Value 2 | Value 3

---

But I would like the table to go the other way. Headings going down, each in its own row with values from sql to the right of them.

Heading 1 | Value 1
Heading 2 | Value 2
Heading 3 | Value 3

Attached is an example of what the table needs to look like. Sorry, hard to explain. Thanks!

[abduraooft]

PHP Code:

echo "<table border='1'>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<th>Firstname</th>";
echo "<td>" . $row['FirstName'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<th>Lastname</th>";
echo "<td>" . $row['LastName'] . "</td>";
echo "</tr>";
}
echo "</table>"; 


[macbb1117]

Wow. I feel really stupid now. I was making that way too complicated. Thanks so much for your quick response!