user Validation + Some Question

[netmastan]

Hi,

I am developing user registration script.

user fill type their username,password and email address.

username,password,email and random id address store in a table(ie.temp_user).

Script send an email to the user with a validation link(with randid). Script check the random id with the random id we have saved in the table(temp_user). If they match then the scrip insert user details in another table(ie.user) and delete user record from "temp_user" table.

As you can see user must validate their information by click on validation link. If the user don't click the validation link their information will stay in the table .... How do i set a time for that user or id ..if they don't validate within 2 days..their record will be deleted automatically . So the "temp_user" table will be clean all the time .

[the_Igel]

You should store in the temp_user the time when a record was added. Then you "delete from temp_user where now() - interval 2 days > creation_time" (I may be unexact a little about the syntax) either on every request of some script (e.g. the one that adds records to temp_user), or, if you have access to cron, once in a while (to lower server load).