Hi there everyone,
Im looking for a solution regarding a project im involved with which needs to run a script that search's between dates.
Im running a table like this example:
ID - date_begin - date_end - price
1 01-01-2009 31-01-2009 1€
2 01-02-2009 14-02-2009 2€
3 15-02-2009 27-03-2009 3€
....
And i have a search box in PHP which allows me to search a date like 15-01-2009.
But I need to search 15-01-2009 and return this date interval (1 01-01-2009 31-01-2009 1€).
Is there any query to make this work?
Thanks in advance