Table rows and database

keithjasper

How can i get each row to display the next coloum on a database...

along the lines of

1 ¦ 2

3 ¦ 4

5 ¦ 6

i can get cols to work but donot know how to do rows.

Thanks

paulnaj

Hi Keith,

You haven't indicated where the database comes in, but this might get you on the road ...

<table border="1">
	<tr>
<?php 
$maxcols = 3;
$maxrows = 5;

$counter = 0;
$row = 0;
while($row < $maxrows){
	echo '
	<td>'.$counter.'</td>';

$counter++;
if(($counter % $maxcols) == 0){
	$row++;
	echo '
</tr>
<tr>';
}
}
?>
	</tr>
</table>

Paul

keithjasper

the 1 2 3 4 5 6 in the above example is ID's queryed from the database... the difficulty i have is displaying these as 2 cells per row as well as 2 ID's per row...

1 2
3 4

are all extracted from database and echoed using


print "<table bordercolor='#000000' border='1'>";
while($row = mysql_fetch_row($result))
{
	print "<tr class='cell'><td class='cell'>";
	print "<font class='barcode'>";
	echo "*" . $row[0] . "*";
	print "</font><font class='text'><br>";
	echo $row[0];
	print "</font></td><td class='cellspace'></td>";
	print "<td class='cell'>ISBN: ";
	echo $row[1];
	print "<br>Title: ";
	echo $row[2];
	print "<br>Author:";
	echo $row[3];
print "</td></tr>";

}

however i know it is something within this code above which is stoping me displaying how i would like.