Need php/mysql coding using DREAMWEAVER MX to display individual product items from a recordset that has multiple attributes. Project has the following 3 tables and fields:
prodid | prodname | proddesc |
1815 Hat Hat with Feather
prodid | color |
prodid | size |
I need the mysql query and php coding to join these tables AND present the product in one line as follows:
Item 1815, Hat, Hat with Feather, Red White Blue, S-M-L
Sample MSAccess data file attached.
1) Complete and fully-functional Dreamweaver MX code required to generate desired result 2) Any mysql queries required to create recordsets 3) Complete ownership and distribution copyrights to all work purchased.
Dreamweaver MX format is necessary.