Row from database

[wolx]

Ok, my table has two fields: start_date and end_date. How could I get only the rows out of the database, where the start_date is before the date right now and the end_date is after the date right now?

My English grammar isn't too good, I hope you understand.. :S

[abduraooft]

.........where start_date < now() and end_date > now()

[wolx]

Now that I see it, In don't get, how I didn't think about it before.. :D Simple. :)

Thanks! :P