Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<p>As it turns out, with some continued searching, I finally found my answer in a script that was posted here:</p> <p><a href="http://roshanbh.com.np/2008/01/populate-triple-drop-down-list-change-options-value-from-database-using-ajax-and-php.html" rel="nofollow">http://roshanbh.com.np/2008/01/populate-triple-drop-down-list-change-options-value-from-database-using-ajax-and-php.html</a></p> <p>It wasn't EXACTLY what I needed, but it was awfully close, and a few modifications did exactly what I needed done. Either create your tables based upon the values in the script, or, if your tables already exist, as in my case, just be careful how you edit/rename all of the variable/table/column names in the script and it will do a terrific job.</p> <p>In my case, although I didn't really need a "three step" drop down (and my database tables structure didn't provide the means for it), I used the script pretty much as is, but I removed the "where" clause from the mysql query within the findState.php file, thus listing ALL entries from that table instead of only ones that matched the ID from the first selection box.</p> <p>Hopefully, if you download the files from the link above and open them up, the explanation above will be more clear.</p> <p>Sorry I can't explain all the programming. I'm not a programmer and don't always FULLY understand all the code, but I'm pretty good at taking scripts other people have written and modifying them for my own purposes.</p> <p>Feel free to ask questions, if need be. I'll try to answer as best I can.</p>
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload