Hi,
try this:
SELECT * FROM your_table
WHERE StartDate > NOW()
AND EndDate < NOW()
> Hello,
>
> I am having a problem when doing a SELECT. Here is the
> scenerio:
>
> I have a table that has an event StartDate and
> EndDate, based on the current Date "NOW()" I need to
> know which records are
I guess MySQL is a DBMS ans not a frontend.
> thanks for the reply,
>
> i have tried limit , but i want 10 records at a time and when i hit
> "return
> key" i will show next 10 records, and so on. how i can achieve this .
>
> sanjay
> - Original Message -
> From: "Victoria Reznichenko" <[E
