And here is the activation column image: http://i.imgur.com/o78NGVs.png
If the person gets the activation email in his email account and he clicks it, the activation column should change the value from 0 to 1, if he doesn't clicks it. There should be like a timer. If he doesn't clicks within 24 hours, it gets deleted from the db.
Here is a link of a PHP script that has a built in email activation required. The script is simple enough to modify. For a fee, I can modify the script to use PDO, instead of almost deprecated regular MySQL.
Sep 8th, 2013
Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.