Dividing Row By MySQL result

[asyadiqin]

I would like to display list of numbers from a database and format it in such a specific way.

The result will be in a table with 3 columns and separate by 5 records in a column. Example is shown below :-

---

| 001 | 002 | 003 |
| 004 | 005 | 006 |
| 007 | 008 | 009 |
| 010 | 011 | 012 |

| 013 | 014 | 015 |

| 016 | 017 | 018 |
| 019 | 020 | 021 |
| 022 | 023 | 024 |
| 025 | 026 | 027 |

| 028 |----------------|

Is there way to do it in PHP? I am quite new to PHP and any help is greatly appreciated.

[Shrike]

Before you start iterating through the record set create a counter and set to 0

$i = 0;
while($row = mysql_fetch_array($result)){
  echo "<tr><td>| $row[0] | $row[1] | $row[2] |</td></tr>";
  $i++;
  if($i == 5){
     echo "<tr><td>|-----------|</td></tr>
     $i = 0;
  }
}

[mphllps]

Hello take a look at this example code. I think it is basically what you want. I've created an array to simulate database results. Instead of the for ($i=0;$i<count($array);$i++) you would have
while($row=mysql_fetch_array($result) { and instead of $array[$i] you would have $row[0]

<table border=1>
	<tr>
<?
$r=0;//Row counter
$c=0;//Column counter
$array=array('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30');
for ($i=0;$i<count($array);$i++) {
	echo "<td>".$array[$i]."</td>\n";
	$c++;//Increment column position
	if ($c==3) { // End of column, start new row
		echo "</tr><tr>\n";
		$c=0;//Reset row counter
		$r++;//Increment C: end of row
	}
	if ($r==5) { // if row position is at 5 add a spacer row
		echo "<td colspan=3>&nbsp;</td></tr><tr>";
		$r=0;
	}
}
?>
	</tr>
</table>

I hope this helps!

Miles