I have a form on a PHP page that allows a user to enter billing information into a MySQL database. One of the form fields is a drop-down menu that allows the user to select the Client to which to apply the billing input.
Beneath that form is a table which lists all recent transactions from the billing database. I need to modify the table to only display billing entries for a specific client, as selected in the drop-down in the form.
How can I get the client selected from the drop-down menu to execute my MySQL query with the appropriate value and populate the table on the same page, WITHOUT submitting the entire form (which would be blank, since the Client Dropdown is the first input)? The Client drop-down selection can't be reset after it passes the value to the table, since it's still required to submit the input form.
Thanks in advance for your suggestions!