Anyone have an email confirmation script? Basically, I just need the user to verify their email by clicking the link and setting the confirmed field to 1. Visitor signs up. The form contains basic signup information. This is added to the database. The database also contains 2 more fields. Confirmed and ConfCode. Before it enters the row in the database, it generates a 10 digit code and puts it in the confcode field. My thought is to then generate the email using Emailaddress, firstname, and the confcode. something like www.mywebsite.com/confirm.php?code=73FH7G2lIU. Confirm.php would grab the code, search that field in the db for that code, finding it, and change the confirmed field to 1. Anyone have anything like this laying around?