[PHP] SQL Question: Search Records between two dates.

Hello everyone, I need to get a recordset between two dates, and am having a little trouble. I was wondering if someone could me make it more efficient. The goal: Each record has a start_date and end_date field. I want to be able to extract records that has the start_date and/or end_date,

Re: [PHP] SQL Question: Search Records between two dates.

select * from table_name where (start_date ='2002-10-01' and start_date ='2002-12-10') or (end_date ='2002-10-01' and end_date ='2002-12-10') At 01:08 11.12.2002, [-^-!-%- said: [snip] Hello everyone, I need to get a recordset between two dates, and am