Professional Web Applications Themes

Printing mysql_fetch_array results in multicolumn table - MySQL

I'm not sure if this qualifies as a mysql or a php question so I'm asking in both groups. I am pulling the results of a mysql query from my database and want to print the results into a two column table. I know how to get the results into a single column table just fine using: while($row = mysql_fetch_array($result)) { print "<table border=2><tr><th>" . $row[name]; print "<tr><td>"; print mysql_field_name($result, 0) . ": " . $row[ID]."<br>"; print mysql_field_name($result, 1) . ": " . $row[name]."<br>"; print mysql_field_name($result, 2) . ": " . $row[address]."<br>"; print mysql_field_name($result, 3) . ": " . $row[city]."<br>"; ...

  1. #1

    Default Printing mysql_fetch_array results in multicolumn table

    I'm not sure if this qualifies as a mysql or a php question so I'm
    asking in both groups.

    I am pulling the results of a mysql query from my database and want to
    print the results into a two column table. I know how to get the results
    into a single column table just fine using:

    while($row = mysql_fetch_array($result)) {
    print "<table border=2><tr><th>" . $row[name];
    print "<tr><td>";
    print mysql_field_name($result, 0) . ": " . $row[ID]."<br>";
    print mysql_field_name($result, 1) . ": " . $row[name]."<br>";
    print mysql_field_name($result, 2) . ": " . $row[address]."<br>";
    print mysql_field_name($result, 3) . ": " . $row[city]."<br>";
    print mysql_field_name($result, 4) . ": " . $row[telephone]."<br>";
    print "</td></tr>";
    print "</table>\n";
    print "<br><br>";
    }

    and it works fine. But my efforts to get the reults into a two column
    setup have become frustrating. My latest attempt was:

    while($row = mysql_fetch_array($result)) {
    print "<table border=2 width='90%'>";
    print "<tr>";
    print "<td>";
    print "<b>" . $row[name] . "</b><br>";
    print mysql_field_name($result, 0) . ": " . $row[ID]."<br>";
    print mysql_field_name($result, 1) . ": " . $row[name]."<br>";
    print mysql_field_name($result, 2) . ": " . $row[address]."<br>";
    print mysql_field_name($result, 3) . ": " . $row[city]."<br>";
    print mysql_field_name($result, 4) . ": " . $row[telephone]."<br>";
    print "</td>";
    print "<td>";
    print mysql_field_name($result, 0) . ": " . $row[ID]."<br>";
    print mysql_field_name($result, 1) . ": " . $row[name]."<br>";
    print mysql_field_name($result, 2) . ": " . $row[address]."<br>";
    print mysql_field_name($result, 3) . ": " . $row[city]."<br>";
    print mysql_field_name($result, 4) . ": " . $row[telephone]."<br>";
    print "</td>";
    print "</tr>";
    print "</table>\n";
    print "<br><br>";
    }

    This puts the same data from a single result in both <td> fields though.
    I want it to put data from the first result in the left <td> and data
    from the second result in the right side and continue on from there
    until the end.

    What am I overlooking on this to make it work as I need it to?
    JackM Guest

  2. #2

    Default Re: Printing mysql_fetch_array results in multicolumn table

    JackM wrote:
    > I'm not sure if this qualifies as a mysql or a php question so I'm
    > asking in both groups.
    >
    > I am pulling the results of a mysql query from my database and want to
    > print the results into a two column table. I know how to get the results
    > into a single column table just fine using:
    >
    > while($row = mysql_fetch_array($result)) {
    > print "<table border=2><tr><th>" . $row[name];
    > print "<tr><td>";
    > print mysql_field_name($result, 0) . ": " . $row[ID]."<br>";
    > print mysql_field_name($result, 1) . ": " . $row[name]."<br>";
    > print mysql_field_name($result, 2) . ": " . $row[address]."<br>";
    > print mysql_field_name($result, 3) . ": " . $row[city]."<br>";
    > print mysql_field_name($result, 4) . ": " . $row[telephone]."<br>";
    > print "</td></tr>";
    > print "</table>\n";
    > print "<br><br>";
    > }
    >
    > and it works fine. But my efforts to get the reults into a two column
    > setup have become frustrating. My latest attempt was:
    >
    > while($row = mysql_fetch_array($result)) {
    > print "<table border=2 width='90%'>";
    > print "<tr>";
    > print "<td>";
    > print "<b>" . $row[name] . "</b><br>";
    > print mysql_field_name($result, 0) . ": " . $row[ID]."<br>";
    > print mysql_field_name($result, 1) . ": " . $row[name]."<br>";
    > print mysql_field_name($result, 2) . ": " . $row[address]."<br>";
    > print mysql_field_name($result, 3) . ": " . $row[city]."<br>";
    > print mysql_field_name($result, 4) . ": " . $row[telephone]."<br>";
    > print "</td>";
    > print "<td>";
    > print mysql_field_name($result, 0) . ": " . $row[ID]."<br>";
    > print mysql_field_name($result, 1) . ": " . $row[name]."<br>";
    > print mysql_field_name($result, 2) . ": " . $row[address]."<br>";
    > print mysql_field_name($result, 3) . ": " . $row[city]."<br>";
    > print mysql_field_name($result, 4) . ": " . $row[telephone]."<br>";
    > print "</td>";
    > print "</tr>";
    > print "</table>\n";
    > print "<br><br>";
    > }
    >
    > This puts the same data from a single result in both <td> fields though.
    > I want it to put data from the first result in the left <td> and data
    > from the second result in the right side and continue on from there
    > until the end.
    >
    > What am I overlooking on this to make it work as I need it to?
    Not completely sure what you want exactly, but there are some weird
    constructs in both cases. You create a complete table for each db row it
    seems. The table tages should be outside the loop I suppose.

    It is no surprise in the second example you get the same data in both
    columns, since that is what you ordered. If what you aim for is a table
    looking like this:

    ID <ID value for row x>
    name <name value for row x>

    [etc]

    ID <ID value for row y>
    name <name value for row y>

    [etc]

    then replace all the <td> </td> contents of the first column with
    appropriate contents.

    Sh.
    --
    Sigh. I like to think it's just the Linux people who want to be on
    the "leading edge" so bad they walk right off the precipice.
    (Craig E. Groeschel)
    Schraalhans Keukenmeester Guest

Similar Threads

  1. Query results don't display properly in results table.IGNORE PREVIOUS
    By JoyRose in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: March 24th, 07:28 PM
  2. Query results don't display properly in results table.
    By JoyRose in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: March 24th, 07:17 PM
  3. Use results from query to search a different table
    By bob2cam in forum Coldfusion Database Access
    Replies: 1
    Last Post: March 19th, 04:49 PM
  4. Multiple-row table formatting of results
    By Daniel Ruscoe in forum PHP Development
    Replies: 1
    Last Post: November 16th, 05:56 PM
  5. Printing Search Results
    By Sarah in forum Windows XP/2000/ME
    Replies: 3
    Last Post: July 15th, 07:57 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139