PHP Cascading DropDowns using MySQL
Posted: Thu Jul 22, 2010 5:09 pm
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
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