[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