Date from and date to fields

[dc_jt]

Hi

 

I have a table which contains special offers starting from a certain date and ending at another date.

 

Therefore would I just do

 

$date = date("Y-m-d H:i:s ");

 

SELECT * from Tablename

WHERE start_date <= '$date' &&

end_date >= '$date'

 

Is this correct?

 

Thanks

[johng]

I'm not sure, it may depend on what sql you run, but I just use "and" [where start_date <= '$date' and end_date >=$date] or you may even be able to use "between" [where '$date' between start_date and end_date] (I use "between" but usually it is the other way around, I have two date variables and only one database field I am looking for)  Hope this helped more than hurt, and good luck.