[RESOLVED] results within date frame

zzz

I have two fields in db table:

startDate (date) and endDate (date)

I need to return results if today falls between these dates

Can i do something like:

SELECT * FROM t1
WHERE...
AND startDate > NOW()
AND endDate < NOW()

devinemke

SELECT * FROM table WHERE NOW() BETWEEN startDate AND endDate

zzz

I guess I just like to complicate simple things... I even put it in my signature.

zzz

SELECT * FROM table WHERE NOW() BETWEEN startDate AND endDate

This worked great, but then I put all my functionality into a function to reuse couple of times and when I use this string I get no results, however if I take it our and leave the rest of the query it works again.

Somehow I feel my script does not understand what is NOW()

Not sure what am I missing...

devinemke

the NOW() has nothing to do with PHP. it is a mySQL function. if your code works outside of your function and does not within your function that i suggest you are having problems with variable scope

zzz

Yes, I am aware that NOW() is a MySQL function, that is why I can not understand why won't it work... Regardless whether it is in a function or not, NOW() is "now".

I was trying to figure out a work around solution but substituting NOW with something like

$today = date("Y-m-d");
...
SELECT * FROM table WHERE ".$today." BETWEEN startDate AND endDate

but did not get too far either... bummed up...

zzz

my mistake all along... dumb logic. I actually did not even need the date span... coffee, i need coffee...:o