Jump to content

Stuck, on populating multiple lists


tndmad

Recommended Posts

Ok, so i got this website project dropped in my lap, and I'm stuck not really having done much php coding ever.  I have a database which is linked already, and it was working when pulling data from a specific table.  The problem arose when I was asked to make it work with other tables.  I have a table with the table names in it, and the drop down field to select the table populates.  The next field is a multiple select field that is supposed to populate report dates from the previously selected table, and then finally the last multiple select field is supposed to populate with names that match the dates selected from the previous field.  The last one I can live without, as the existing code takes into account if the name selected doesn't exist in the table with the selected date, but at the moment the date field just comes up blank.  Any help would be greatly appreciated.

 

[attachment deleted by admin]

Link to comment
https://forums.phpfreaks.com/topic/229253-stuck-on-populating-multiple-lists/
Share on other sites

You will need to do one of either 2 things:

re-submit the page each time a new selection is made along the chane, using an independant form for each stage and some conditional execution options ...or... take up javascript and run each sub querie through the OnChange/OnBlur events.

I attempted something like that on the omhomepage file.  I'm trying to keep only the functions in the om_utilities file, and then call them from the omHomepage one.  I know only the basics of web programming unfortunately, and never really had any experience with javascript or php, though the php reminds me of my c++ days at least at first glance.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.