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? Link to comment https://forums.phpfreaks.com/topic/32987-changing-recordset-data-by-drop-downs/ 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 Link to comment https://forums.phpfreaks.com/topic/32987-changing-recordset-data-by-drop-downs/#findComment-153649 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. Link to comment https://forums.phpfreaks.com/topic/32987-changing-recordset-data-by-drop-downs/#findComment-155084 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.