Hello friends. Sorry I sent the wrong code in my last mail. Here is my correct code.
I want the output of my query to be formatted such that after every 7th output, the 8th one should start on a new row in the table. I have written the following code but does not work. Can someone please help? Quote : <table width="800" border="0" cellspacing="0" cellpadding="3"> <tr> <?php $i=0; while($row=mysql_fetch_array($result)){ $i=$i+1; if ($i==7){ Print "</tr><tr>"; Print"<td width=\"150\" >"; Print "<a href=\"findbycategory.php?"."CategoryId=".$row["CategoryId"] ."\"><font color=\"#000040\" size=\"2\">$row[CategoryName]</font></a>"." "; Print "</td>"; }else{ Print "<tr>"; Print"<td width=\"150\" >"; Print "<a href=\"findbycategory.php?"."CategoryId=".$row["CategoryId"] ."\"><font color=\"#000040\" size=\"2\">$row[CategoryName]</font></a>"." "; Print "</td>"; if ($i==6){ Print "</tr>"; }} } ?> <div align="center"> </div></td> </tr> </table> Unquote. Thanks very much. Denis