PHP Code Question

[TheWaterboy08]

I am querying a database and outputting the results to a html page. I want to display the results in a table with two columns as follows:

<table>

<tr>
<td> First Result Here</td>
<td> Second Result Here</td>
</tr>
<tr>
<td> Third Result Here</td>
<td> Fourth Result Here etc etc..</td>
</tr>
</table>

Is this possible and if so can anyone tell me the code on how to get this table format.

[Weedpacket]

Try searching the forums, that's why they're archived. You get your answer if you try searching for two columns in the thread titles.

[adi]

I would do somethink like this:

<?php

$result=mysql_query("SELECT  name FROM whatever");
$a=array();
while ($row = mysql_fetch_array($result))
 {
$a[]=$row['name'];
}
$nr=count($a);
print '<table> ';
for ($i=0; $i<$nr; $i++)
{
print '<tr><td>';
print "$a[$i]";
print '</td>';
$i++;
print '<td>';
print "$a[$i]";
print '</td></tr>';
 }
print '</table>';

[no_maam]

Does this code work ?
I think im doing something wrong
Sorry, im a newbie.

[adi]

Yes , it works .