[thelist] denormalizing a result set in dreamweaver
Jeremy Weiss
eccentric.one at gmail.com
Fri Feb 8 06:26:19 CST 2008
On Feb 7, 2008 6:35 PM, r937 <rudy at r937.com> wrote:
> he says he has to have it like this --
>
> foo aa 9 bb 3 cc 7
> bar xx 4
> qux mm 5 nn 7 oo 8
Assuming you're using php, you're code will look sort of similar to this....
<table>
<?php do { ?
<tr>
<td>$variable</td>
<?php do { ?>
<td>$variable</td>
<td>$variable</td>
<td>$variable</td>
<td>$variable</td>
<td>$variable</td>
<td>$variable</td>
<?php } while yadda yadda yadda ?>
</tr>
<?php } while bla bla bla ?>
</table>
You probably know this part, but just in case...
Create your record set's first. The second recordset will use a
variable from the first in the WHERE clause. Include the variables in
the right places. Then highlight the area from <tr> to </tr> and do a
repeating region. Then highlight the area from the second <td> to the
last </td> and do a repeating region.
This should work. Let me know if you run into any problems.
-jeremy
More information about the thelist
mailing list