Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Sep 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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'>
    <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!
    Attached Thumbnails Attached Thumbnails Display Results in Table-table.jpg  

  • #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,801
    Thanks
    160
    Thanked 2,216 Times in 2,203 Posts
    Blog Entries
    1
    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>"
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)

  • #3
    New to the CF scene
    Join Date
    Sep 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Wow. I feel really stupid now. I was making that way too complicated. Thanks so much for your quick response!


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •