is it possible to get in 2 recordsets pers row?

[phpjaco]

ok, so lets say you have a large result set and you want the record to display 3 in a row and not one per row.

is this possible?

because you cant say

$show = "<table>"
while ($row = mysql_fetch_array) {
$show .= "<tr><td>Name:</td><td>$row[name]</td>
<td>Surname:</td><tr>$row[surname]</td>
<td>Name:</td><td>$row[name]</td>
<td>Surname:</td></tr>
}
$show .= "</table>"

how do you increment the name and surname fields while still looping throught the current one?!

is this possible?

[paulnaj]

Hi phpjaco,

I'm sure there'll be lot's of variations on this theme ...

<?php
$counter = 0;
$numRowsPerPass = 3;
$trs = '';
$tds = '';
while ($row = mysql_fetch_array){ 
	$tds .= "<td>Name:</td><td>".$row['name']."</td><td>Surname:</td>".$row['surname']."</td>";
	if($counter < $numRowsPerPass){
		$trs .= '<tr>'.$tds.'</tr>'
		$counter = 0;
		$tds = '';
	} else {
		$counter++;
	}
}
$table = "<table>".$trs."</table>";
?>

Paul.