output in multiple columns

[Anon]

Say I have got the following:
$sql_qry = "select col1,col2,col3 from mytable";
$sql_result = mysql_db_query("mydb",$sql_qry) || die(mysql_error());

..then I wanna output my stuff

while($result_array = mysql_fetch_array($sql_result)) {

...a bunch of output stuff here ...
}

This will allow me just to output my results one after the other.

Now, say I want to produce this in a tabular form with multiple <td>'s as:

<table>
<tr>
<td>
$result_array["col1"]
$result_array["col2"]
$result_array["col3"]
</td>
<td>
$result_array["col1"]
$result_array["col2"]
$result_array["col3"]
</td>
</tr>
</table>

How can I do this? If I use a loop construct like for() to loop through some mysql_num_rows(), and use $result_array = mysql_fetch_array($sql_result) in the second <td>, I get errors, the horrible T_^&$$ errors.

Any help?

[Anon]

why for loop? I thinks while loop is
more appropriate here. and you can
add the different columns of the results
to different arrays, and then fire them
at will.

[Anon]

..yeah, I understand I can do a while loop, which is cool. Look at this data in a MySQL database.

---

|fld1|fld2|fld3|

|val1|val2|val3|

|val4|val5|val6|

|val7|val8|val9|

Now, I wanna output this data in an HTML table like so:

<table>
<tr>
<td>
val1<br>
val2<br>
val3<br>
</td>
<td>
val4<br>
val5<br>
val6<br>
</td>
<td>
val7<br>
val8<br>
val9<br>
</td>
</tr>
</table>

[Anon]

$ur_result=mysql_query("select * from yourtable",$your_mysql_connection);

echo "<table><tr>\r\n";
WHILE ($row=mysql_fetch_array($result))
{
echo "<td>$row[0],$row[1],$row[2]</td>";
}
echo "</tr></table>\r\n";

[Anon]

Nooooooo! I want to have, say 1 record (all it's fields) in one <td>, then the next in the other. I think I got it anyway:

Tx for the help. :-)

[Anon]

In case y'all wanna see what I mean by "I got it anyway", check: http://site.mweb.co.zw/users/kiri/php_multiple_columns.cfm