Display Results in Table
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'>
while($row = mysql_fetch_array($result))
echo "<td>" . $row['FirstName'] . "</td>";
echo "<td>" . $row['LastName'] . "</td>";
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!
You want it to say;
If you have more than one row of results what do you want to do?