View Single Post
Old 10-24-2007, 10:27 AM   #3 (permalink)
maZtah
The Acquainted
 
Join Date: Oct 2007
Posts: 170
Thanks: 18
maZtah is an unknown quantity at this point
Default

I'm sorry for the bad explanation.

What I'm trying to achieve is to output it per group. So I have to ORDER it BY the field 'Contract'. But then, per contract I want to output a new <table> with the rows of the same 'Contract'.

Let me try to clearify.

This is my database:

[Id] [Contract] [OtherFields]
[ 1] [Head] [......]
[ 2] [Platina] [......]
[ 3] [Platina] [......]
[ 4] [Bronze] [......]
[ 5] [Bronze] [......]
[ 6] [Bronze] [......]

Then I want to output it as follows (html):

<table>
<tr>
<th>Contract</th>
<th>OtherFields......</th>
</tr><tr>
<td>Head</td>
<td>OtherFields.......</td>
</tr>
</table>

<table>
<tr>
<th>Contract</th>
<th>OtherFields......</th>
</tr><tr>
<td>Platina</td>
<td>OtherFields.......</td>
</tr><tr>
<td>Platina</td>
<td>OtherFields.......</td>
</tr>
</table>

<table>
<tr>
<th>Contract</th>
<th>OtherFields......</th>
</tr><tr>
<td>Bronze</td>
<td>OtherFields.......</td>
</tr><tr>
<td>Bronze</td>
<td>OtherFields.......</td>
</tr><tr>
<td>Bronze</td>
<td>OtherFields.......</td>
</tr>
</table>

I hope it's somewhat more clearyfied now.
Thanks.
maZtah is offline  
Reply With Quote