Splitting MySQL results

[intervelopment]

Hey Ya'll

I have a script im trying to write which im having problems with.

Basically what i want to do is split my results into 2 columns, so for example, if there is 4 results, there will be 2 in each column, if there is 5 results there will be 3 in the first and 2 in the second and so on.

My template is set out in the following format.

<div class="box">
	<div class="row">
		<input name="" type="radio" id="result1" class="radio" />
		<label for="result1">result1</label>
	</div>
	<div class="row">
		<input name="" type="radio" id="result2" class="radio" />
		<label for="result2">result2</label>
	</div>	
</div>

<div class="box">
	<div class="row">
		<input name="" type="radio" id="result3" class="radio" />
		<label for="result3">result3</label>
	</div>
	<div class="row">
		<input name="" type="radio" id="result4" class="radio" />
		<label for="result4">result4</label>
	</div>	
</div>

[dagon]

http://www.phpbuilder.com/board/showthread.php?s=&postid=10593202#post10593202

[intervelopment]

I am quite confused on this.

I have to use the foreach statement, is there a way to use that instead of the for $i=.......

This is my code at the moment, but this only displays it in one column

<div class="box">
	<?php
		foreach($roles as $row){
			echo '<div class="row">';
			echo '	<input name="'.$row->key.'" type="radio" id="'.$row->key.'" class="radio" />';
			echo '	<label for="'.$row->key.'" style="text-transform: lowercase;">'.$row->name.'</label>';
			echo '</div>';
		}
	?>
</div>

[intervelopment]

Anyone?

[dagon]

you can use the array key for the $i assuming its numeric