Selecting date range

[mkili]

Is it possible to select a date range using mysql. I have a table with columns from and till. What I would like is to get valid dates starting on from and ending on till.

[jeremuck]

uhh...

SELECT * FROM table WHERE from = $startdate AND till = $enddate

is that what you want?

[mkili]

No. What I mean is this:
- a row has from='2002-09-29' and till='2002-10-03'
- I want to get :
2002-09-29
2002-09-30
2002-10-01
2002-10-02
2002-10-03

• seems like some virtual table would be necessery

[The_Chancer]

Don't use it like that !!

Use timestamp instead, so you can use the statement provided by Jeremuck.
Then you can pull any date out from there that you would like...

[mkili]

I won't work. Seems it cannot be done. I'll use php