Get data from MySQL table based on the date chosen in a form

Job ID: 32566456

Budget: ₹600 – ₹1,500 INR

This is a very small project. I have two tables: the tax table and the Payment table. The Tax table has the tax percentage applicable for a particular period. For instance, 2019 - 2021, the tax is 4.94%.

I have the Payments table, which I use to generate invoices. If I enter an invoice date, the system should check the date against the Tax table and get the Tax percentage applicable for that time period and show it in the Payments table.

I have attached some screenshots for your reference.