[SOLVED] Display Results in 2 Columns

[affc]

Gday. I am having huge issues and spent a few hours changing this code around and looking else where on the net but cannot get this to work.

 

I am trying to produce the following:

 

1    2

3    4

5    6

7    8

etc etc

 

for some reason all it does it display on 2 rows and i cannot get it to column right please help

 

<?php
$columns = 2;
$sql="SELECT * FROM newsdetails ORDER BY year DESC, fileno DESC";
$result = mysql_query($sql) or die("Couldn't execute query." );
$num_rows = mysql_num_rows($result);
$rows = ceil($num_rows / $columns);
?>
<table width="600" border="1" align="center" cellspacing="2" >
                <?
$index = 0; 
while($row = mysql_fetch_array($result)) { 
if($index == $rows) {
?>
<tr>
<?
}
$index++;
?>
                  <td width="300" valign="top"><img src="<? echo $row['imagefile']; ?>" align="left"></td>
<?
}
?>
</tr></table>

[affc]

Actually I have decided I can use the rows and just limit each database row to 4 which gives me 2 columns of 2 rows,

 

Saves trying to change scripts etc etc