How Would I Acheive This?

[Iceman90]

Hi everyone.

I am looking for a way to achieve a layout like the following layout in the most efficient way possible.


Right now, I was going to have 3 queries, one for the left column, one for the right column, and one for the bottom list. I am using a non-table based layout in CSS.

Is there an easier way to achieve this than by doing 3 db queries?

[php_daemon]

Yes, 1 query. Those are all news, right? Ordered by time, I assume. So it's just a matter of breaking it into 3 separate divs, like:

$i=0;
echo '<div id="right">';
while($row=mysql_fetch_array($r)){
  if($i++==5)echo '</div><div id="left">';
  elseif($i==9) echo '</div><div id="bottom">';
  //...
}
echo '</div>';