tndmad Posted March 1, 2011 Share Posted March 1, 2011 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] Quote Link to comment Share on other sites More sharing options...
Muddy_Funster Posted March 1, 2011 Share Posted March 1, 2011 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. Quote Link to comment Share on other sites More sharing options...
tndmad Posted March 1, 2011 Author Share Posted March 1, 2011 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. Quote Link to comment Share on other sites More sharing options...
tndmad Posted March 2, 2011 Author Share Posted March 2, 2011 Still haven't made any progress on this if anyone looks through the codes and sees my glaring mistake that has inexplicably escaped my attention. Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted March 2, 2011 Share Posted March 2, 2011 You may have better luck if you paste the contents o the attached files between . . . BBCode tags. Most people won't download attached files. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.