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!