<i>DMX2004, PHP_MySQL</i>

I like using MySQL's SET column type, allowing an array of strings or integers. I have an online form that uses a handful of lists/menus. The page is for custom online print orders, so the form elements are:
<ul><li>Size (print)</li><ul><li>Quantity</li><li>Paper stock</li><li>Gloss coating</li></ul></ul>


I own both InterAKT's <i>MX Widgets</i> (has Dependant Dropdown), and WebAssists' <i>Dependant Dropdown</i> from an old MM DRK disc. I've read forum posts about n-n relationships MX Widgets' Dependant Dropdown not work like this by default, so I'm hoping someone has a hand-code idea/way, or a tip for either MXW-DD or WA-DD.


In general, for the database, I've thought about this two ways:
<ul><li>Size is the master record; Qty, Paper, Gloss each have SET column with multiple ID's of SizeID's.</li>
<li>Size has three SET columns - one for Qty, Paper, Gloss.</li></ul>



... hope I explained those okay. <img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>

Hey Chris,

I have an asp solution.....

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>I have an asp solution.....<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
Ah, cool Vince! Lemme hear it please, I did ASP up until almost a full year ago since PHP got my new fancy.

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>