I want build and extract data from a mysql table by date. The problem is that my table data needs to be by date range as follows.
Example: key field is DATE field
row 1: 02-19-96 to 02-06-97
row 2: 02-07-97 to 01-27-98
row 3: 01-28-98 to 02-15-99
and the input for the query will come from a FORM input (without range), example:
input value could be 05-13-96
How can I query the table and select the row with the correct range.
Baffled newbie !