Resluts formating

[thoand]

Is it posible to make a database query ordered by date desc(yyyymmdd)
and the format the result in an html table like this:

---

|1 |

|2 |3 |

|4 |5 |

|6 |

|7 |

|8 |

... and so on.

I need a clean solution, anyone had a similiar challenge?

[thoand]

I need to do something like the layout here:

http://www.propaganda-as.no

You see the query is not just rows, but, rows and 2 columns + 2 columns etc.

[PyroX]

Not a challenge...

... ORDER BY date DESC ....

( newest dates first )

then to format in table:

CONNECT, QUERY, AND SHOW RESULTS

$db=mysql_connect($host,$user,$pass);
$res=mysql_query("SELECT * FROM ... ORDER BY date DESC",$db);
echo "<TABLE>";
while($row=mysql_fetch_array($res)){
echo "<TR>";
for($x;$x<count($row);x++){
echo "<TD>".$row[$x]."</TD>";
}
echo "</TR>";
}
echo "</TABLE>";