outputting a couple columns

Anon

I know I saw this sometime back, and I did try to make a mental note but.... I would like to print out my results in a while loop and get 2 results printed per html table row.
<PRE>
<TR><TD>$foo</TD>
<TD>$foo</TD></TR>"; }
</PRE>
something like that, then print out the next row.
anyone?
Thanks

Anon

$linkID = mysql_connect("host", "user", "pass");

$resultIndex = mysql_query("YOUR QUERY", $linkID);

// Now you can fetch an an associative array...

while ($rr = mysql_fetch_array($result_id)) {
echo "<tr>\n<td>" . $rr["column1"] . "</td>\n<td>" . $rr["column2"] . "</td>\n</tr>\n";
}

// ...or a regular array...

while ($rr = mysql_fetch_row($result_id)) {
echo "<tr>\n<td>" . $rr[0] . "</td>\n<td>" . $rr[1] . "</td>\n</tr>\n";
}

HTH,
adam

Anon

Thanks, I don't think I explained my situation very well let me try again.
I will select several columns from a database and it should return several rows.
What I would like to do is after printing out my whole set of variables, begin another set in the cell to the right, when that set is finished close out the row and begin a new row.
<PRE>

name name
rank rank
serial number serial number

</PRE>

Hope I was able to explain myself better this time.
TIA

Anon

I don't think it's possible to build columns before rows in a single HTML table. The only way I can think to do that is to make each "cell" (as you described them above) a single-column HTML table nested inside another, structural HTML table. Something like:

<table cellspacing="0" cellpadding="2" border="0">
<tr>
<td>
<table cellspacing="0" cellpadding="4" border="0">
<tr><td>name</td></tr>
<tr><td>rank</td></tr>
<tr><td>serial number</td></tr>
</table>
</td>
<td>
<table cellspacing="0" cellpadding="4" border="0">
<tr><td>name</td></tr>
<tr><td>rank</td></tr>
<tr><td>serial number</td></tr>
</table>
</td>
</tr>
</table>

Then you just have to replace the data I copied from you example with the value of the associative array at that point and put in some logic to generate the right number of nested tables to match the size of your query result.

Anon

I believe this is what you are looking for 🙂

echo '<tr>'
for($i = 0; $row = mysql_fetch_assoc($result); $i++)
{
  // every 2 line begin a new row
  if($i % 2 == 0)
  {
    echo '</tr><tr>';
  }
  echo '<td>blah blah blah</td>';
}
echo '</tr>';

Anon

$typo = "// every 2 line begin a new row";
if(strpos($example_code, $typo) !== false)
{
  echo "That should be: // every 2 columns begin a new row ";
}

😉