Hello Dear all,
i have created a html page to insert data in sql table. my html page have date , month and year columns. which is stored in sql table in their respective columns.
now i want to retrieve data from sql table in a php page.
but i want to use a condition to select data.
and condition is that the data must be between two specify dates.
now i am confused how can i match 6 values in a query.
Example: Find the data between Day 02 Month March Year 2010 and Day 30 Month November year 2010.
because my sql table have different columns to store day , month and year.
please help me to solve it.