Limiting Rows in Table

cap97

How would one limit the number of rows to appear before moving to the next? (Or is it columns I'm looking for?) In other words, if I had six results to a query and wanted to have three per line, like this:


<TABLE>
 <TR>
  <TD>result1</TD><TD>result2</TD><TD>result3</TD>
 </TR>
 <TR> 
  <TD>result4</TD><TD>result 5</TD><TD>result6</TD>
 </TR>
</TABLE>

The way I do it now, it goes:


<TABLE>
 <TR>
  <TD>result1</TD><TD>result2</TD><TD>result3</TD><TD>result4</TD><TD>result5</TD><TD>result6</TD>
 </TR>
</TABLE>

Get me? Is this possible?

Tewl

yes its possible its pretty simple actually here is an example of doing it with mysql

<?php

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
?>

<TABLE>
 <TR>
  <TD><?php echo $row[0]; ?></TD><TD><?php echo $row[1]; ?></TD><TD><?php echo $row[2]; ?></TD>
 </TR>
 <TR> 
  <TD><?php echo $row[3]; ?></TD><TD><?php echo $row[4]; ?></TD><TD><?php echo $row[5]; ?></TD>
 </TR>
</TABLE>

<?php

}

?>

cap97

Okay, thanks but what if I had 200 results in the query? Is there a more automated way to do it?

Tewl

for each row it will draw a new table

Tewl

the row[0] 0-5 is jsut going through all 6 columns

intenz

Try this...

$i = 0;
$perrow = 3;
while( $myrow = mysql_fetch_assoc( $query ) )
{
	if( $i == 0 )
		echo '<tr>';
	$i++;
	echo '<td>' . $myrow['fle'] . '</td>';
	if( $i == $perrow )
	{
		echo '</tr>';
		$i = 0;
	}
}

if( $i != $perrow )
	echo '</tr>';

cap97

Man! That's genius. And it seems to easy once you see how it works. Thanks!

Mike....