[SOLVED] Simple SELECT statement question

[Siggles]

Hi, I have a dbase with some gigs that has a date field. The SELECT statement currently says...

 

SELECT * FROM `Gigs` ORDER BY `Eventdate` ASC LIMIT 3

 

which works fine but I also want the statement to only show gigs that havent happened yet or that are > than today's day. I tried WHERE Evevntdate > CURRENT_DATE or something along those lines but so far havent got it to work.

 

Any ideas?

 

Thanks

[BenInBlack]

well in MySql it is

 

SELECT *

FROM Gigs

WHERE date(Eventdate) >= CURRENT_DATE()

ORDER BY Eventdate ASC

LIMIT 3

[Siggles]

Great! Works! Thanks!