Selecting Date Range

[denny]

I am trying to display a list of names that will be expiring in the next 30, 60 or 90 days. It works fine except it also shows the names that have already expired. I don't want it to show expired names just what is expiring in the future. The code below displays what is expiring in the next 30 days.

$result = mysql_query("SELECT name, expiration FROM domains
       WHERE expiration <= Now() + interval 2592000 second
       ORDER BY expiration"); 

Thanks

[r937]

WHERE expiration > Now()
AND expiration <= Now() + interval 2592000 second

rudy

[denny]

hahah I knew it was going to be something simple.. I guess I was having a brain fart..

Thanks Rudy..