ericsante Posted January 5, 2007 Share Posted January 5, 2007 I am trying to write some reporting for my application.I have a table with customers, and a table with date ranges called period (start and end).I want to display a recordset for the customer selected from a dropdown list and the period selected from a second dropdown.so once the data is selected I want to be able to change the selected period for the same customer or change the customer for the same period.I have the mySQL queries working just fine, I have tested my reports where I can pass $_GET's to and it works.I just don't know how to put together the dropdowns from the other tables and the post to get it all working.Any suggestions? Quote Link to comment Share on other sites More sharing options...
Stooney Posted January 5, 2007 Share Posted January 5, 2007 http://www.w3schools.com/tags/tag_select.asp Quote Link to comment Share on other sites More sharing options...
ericsante Posted January 7, 2007 Author Share Posted January 7, 2007 thx, I know how to build a drop down list, however I need to build 3 of them from 2 tables, and then submit them to the sql query when the options are changed. 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.