Re: [PHP] How to confirm subscriptions by e-mail on a PHP site ?

2005-05-20 Thread Marcus Joyce
The way i did it was, put a 25char hash inside the "registered" column, then sent an email to the user containing something like domain.com?user=id_number&hash=hash then i did "select userID where userID = $_GET['user'] & registered = $_GET['hash']" (not exactly the sql phrase, but i dont feel li

Re: [PHP] Refresh (F5) adds another SQL record.

2005-05-17 Thread Marcus Joyce
Why dont you check that data isnt being duplicated? $query = "SELECT auto_col FROM table where col1 = $var1 & col2 = $var 3."; $call_query = mysql_query($query,... $query_data = mysql_assoc($call_query); if(!$query_data) { do form } else echo "information already exists in databas

Re: [PHP] Why not @ ?

2005-03-22 Thread Marcus Joyce
o:[EMAIL PROTECTED] would be broken. Marcus Joyce Mário Gamito wrote: Hi, If you care to take a peak at http://www.dte.ua.pt/cv/ and pass your mouse over the link "Mário Gamito", you'll see in the status bar that the link is: http://www.dte.ua.pt/cv/[EMAIL PROTECTED] Allright. However,