using varchar for date format? :rofl:
use mysql CURDATE() method
ill give you an example .. eg : mysql_query = "insert into regdates(user_id,user_date)values(xx,CURDATE())";
use this method to get expire date ..example code :
$expdate=time() + 60 * 60 * 24 * 7;(*7 = after 7 days )