how to break while loop some specific records

[realcoder]

i am fetching some data from my database
want to know that how can i show 4 or 5 or etc records in one td then automatic start next tr
this is code
my code fetching all record in td i want to separte record after few record
someone explain

my code is like

$que = "SELECT * FROM movies where catid='$id'";

$exe = mysql_query($que);
while ($get = mysql_fetch_array($exe)){

            echo"<td height='400' align='left' valign='top'><a href='songs.php?movie=".$get['name']."'>".$get['name']."<br/><img width='100' height='130' src='".$get['picture']."' /></a>
            </td>";

please help buddies

[niroshan]

Hi realcoder,

Hope this helps,

<table border="1" width="100%">
<?php
$que = "SELECT * FROM movies where catid='$id'";

$exe = mysql_query($que);
$i=0;
$noOfCols = 4;
while($get = mysql_fetch_array($exe))
{
	if($i==0)
		echo '<tr>';

echo "<td height='400' align='left' valign='top'><a href='songs.php?movie=".$get['name']."'>".$get['name']."<br/><img width='100' height='130' src='".$get['picture']."' /></a></td>";

$i++;
if($i==$noOfCols)
{
	echo '</tr>';
	$i=0;
}
}

if($i <> 0)
{
	$rest = $noOfCols - $i;

for($x=0;$x < $rest;$x++)
{
	echo '<td>&nbsp;</td>';
}
echo '</tr>';
}
?>
</table>

Best regards,
niroshan

[realcoder]

THANKS DEAR