help nesting recordsets php mysql

[jbtilley]

Im not sure if this can be done in php/mysql/dreamweaver, but I know it works in asp.

To make things simple let's say that I have two tables customers and orders:

customer orders
id name custID orderedThing
1 bob 1 book
2 sally 2 ruler
3 jeff 1 pencil
3 protractor

I want to display the results in a nested recordset like this:

1 bob
book
pencil
2 sally
ruler
3 jeff
protractor

Is there a way to do this with dreamweaver/php/mysql/apache?

Thanks in advance for any input.

 

[Cheech]

yes just select the customerid from with one recordset create the other recordset as normal and cut&paste the code into a repeat region.

Cheech

[Peace][Pipe]
The secret of life is honesty and fair dealing. If you can fake that, you've got it made.
Groucho Marx (1895-1977)