Date comparison, how can i do it?

[Anon]

Hi,

I building an application which has a time limited access for visitors...

I have the date until a certain user can get in stored in the database.

BUT how can i compare that date to the curent date and let the user in or NOT.
If the date isn't passed.

Thanks,
Gerry

[Anon]

Well, that depends on what db you are using. If you are using MySQL you could do:

select if($datefield>now(),1,0) as valid where user_id=$user_id;

This will return 1 (true) if the user is still valid (i.e. the stored date is greater than the current date, meaning it hasn't expired) and 0 (false) if they have expired.