Activation email - Insert time() into timestamp

[cozzy1984]

Actually managed to somehow get my email working so that it send an email with their registration details when they signup. Now im looking to do an account activation with the email, making it send out a unique url for them to click. Read about using the users password and a timestamp to create the url, however it didnt go into much detail. It said to create a field with a timestamp and use the time() to insert the timestamp into this, the encode it in the url with the users password. Thing is, when i use the $t = time(); and then try to insert the $t into the tablle it comes up always as 0000-00-00 (and the rest all 0's).

 

Just wondering is there anyone who could help me on this matter, ot even suggest a better way for account activation if this doesn't seem the best option.

 

Cheers