Try this: Query output trouble!

[vikcious]

I wonder if someone knows how to do the follwing thing! Any help would be highly apreciated! :-)
I want to output the result form a simple query - let's say 300 row in $result - to a html table that must have two (2) columns: the first must contain the first - let's say - 150 rows from the query and the other one the last 150??? Smth like:

<tr><td>result 1</td> --><td>result 151</td></tr>
<tr><td>result 2</td> --><td>result 152</td></tr>
.......................
<tr><td>result 149</td> --><td>result 299</td></tr>
<tr><td>result 150</td> --><td>result 300</td></tr>

I just don't seem to get this working the right way! So I shal be grateful for any idea or code snippet!

Regards,
Vik

[samscripts]

hi,
simplest way would be to loop through the results and store them in an array, then loop through that whilst outputting the table:

eg:

$res = mysql_query($yourquery);

$resarray = array();

while( $resarray[] = mysql_fetch_assoc($res));

for( $i = 0; $i < 150; $i++){
echo '<tr><td>'.$resarray[$i]['field'].'</td>'
echo '<td>'.$resarray[$i+150]['field'].'</td></tr>'
}

would that work for you?

sam