limiting records in a table

[php_2004]

Hi,

Im trying to think away around a problem. Basically im printing an image link from mysql database, what im having a problem is, that i want to print three image links to a table row <tr>, then continue with the remaining links held on the database.

The query is at present, as follows:

SELECT * from images order by imageid DESC

So looking at someway of limiting the output to three, then carry on.

image 9 | image 8 | image 7

image 6 | image 5 | image 4

image 3 | image 2 | image 1

etc...

Thanks for any help

[bastien]

use a simple counter and modulus check to write the <tr> tags

...
$x=0;
echo "<table><tr>";
while ($rows=mysql_fetch_array($result)){

 echo "<td>img src='";
 echo $rows['image'];
 echo "'></td>";

  if ($x % 3 == 0 ){
      echo "</tr><tr>";
  }
   $x++;
}//end while