10-24-2007, 10:27 AM
|
#3 (permalink)
|
|
The Acquainted
Join Date: Oct 2007
Posts: 170
Thanks: 18
|
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.
|
|
|
|