php and mysql less than date

[marjune]

i really need this problem solve asap, how can i select  all dates from the data base less than or equal the given date FOR EXAMPLE THE GIVEN DATE IS SEP 22 2009 THEN,

FROM JAN 1 2009 UP TO SEP 22 2009 WOULD BE THE RESULT.

THANKZZZZZZZZ

[Geek-9pm]

Here is one possible solution:

Code: [Select]

SELECT *
FROM Store_Information
WHERE Date BETWEEN 'Jan-01-2008' AND 'Oct-04-2009'
If you had a table called Store_Information.
Is that what you want?

[marjune]

thank you for your time but i got it in other way