formatting query results

[eluser]xwero[/eluser]
[quote author="Steve Grant" date="1223910304"]
Your best bet is probably to use a for loop rather than foreach, as you then effectively create your own array indexing.

Something like...

Code:

<ul>
&lt;?php for($i = 0; $i < count($items); $i++): ?&gt;
  &lt;?php $item = $items->result(); ?&gt;
  <li&lt;?php if(($i + 1) % 3 == 0): ?&gt; class="classname"&lt;?php endif; ?&gt;>&lt;?php echo $item->name; ?&gt;
&lt;?php endfor; ?&gt;
</ul>

[/quote]
You can do it with a foreach loop by using the key.

Code:

<ul>&lt;?php foreach($items as $i=>$item): ?&gt;
<li&lt;?php if(($i+1) % 3 == 0) echo ' class="classname"' ?&gt;>&lt;?php echo $item->name ?&gt;</li>&lt;?php endforeach ?&gt;
</ul>