am here SELECT * FROM `bonussaveoffers` where todate>'2010-09-03' and todate > '-0-0' and offer_name='Nature Retreat Package' order by fromdate