PHP Cascading DropDowns using MySQL

[sleven1868]

Hello,

I am using CMS Made Simple 1.7.1 "Escada".  PHP Version 5.2.13.  I am trying to create 3 dropdowns.  The first is a dropdown select from a mysql database and the second is a query based on the selection from the first and the third is a query based on the selection from the second.  I tried to use a user defined tag to do this but I couldnt figure out a way to pass the ID to each query in the code to get the right list.  I also tried using the CTLModule maker to accomplish this but I couldn't figure it out.  I have example code on how to do this outside of CMSmadeSimple but I couldnt convert it to work inside of Formbuilder with UDT fields.  My thought is that this can be accomplished using one or a combination of FormBuilder, UDT, CTLModuleMaker.  Any help would be greatly apprecited.

Niraj