[SOLVED] query return in columns...

[AV1611]

I'm doing a simple query. (select single_field from table)

I need to display the results in a table with the $row in this order

1  2
3  4
5  6
7

etc...

the number of returns are up to 26...

Not sure how to make the table come out...???

Suggestions?

[trq]

There is a thread covering this subject in the [url=http://www.phpfreaks.com/forums/index.php/board,41.0.html]FAQ/Snippet Repository[/url].

[chronister]

[code]<?
// query db and get results.... loop through them and add to an array

$result_array[]="results from database"
$x=0;    // set a counter to 0
?>

<table  >

<?
while($x < count($result_array)){
?> 
<tr>  <td> <?=$result_array[$x++] ?>  </td>  <td><?=$result_array[$x++] ?></td>  </tr> 
} 
?>

</table>[/code]


This will produce a 2 column table for the results being displayed.

[AV1611]

Brilliant!  Stupendously Simple!  I feel stupid for not figuring that out myselv  :P

[chronister]

I was pretty happy that I came up with that bit of code myself. Its expandable too, just copy/paste the <td>......</td> and it gives you another column

The other examples are too damn lengthy for me. I see no need to run for loops and calculate what freaking column we are on and all that jazz.....this is simple and to the point.


enjoy