email confirmation

[eskimo]

Hey all

I am working on a sort of classifieds script
3 Questions:

Question 1

I need to make it so a user has to confirm their posting via email.
What is the best/easiest way to do this?

Basically i have a table with:
ad id
ad title
ad content
email address
active

"active" will have either a value of 0 or 1 (0 for not active, 1 for active)
how can i make it so the user is send an email with a link to activate their ad?​

Question 2

How can i make it that the ads automatically expire after a certain amount of time? i imagine i need another record in the table (post date). how will i make it do this automatically?


Question 3

Damn... forgot the 3rd question...

 

[codeguardian]

How

1. just send then a emal with a link back to a page on your site just add number to the end like so www.mysite.com/aproved.php?id=3423432. You can use something like m5 with php to create a number that coridnates with the id field in you database. Then just update the table field to 1.

2. just add a filed and use PHP time() function to make the time. The simplist thing is in you search you just do not display listings that are over the time you set in the added field.

LCT
[email protected]