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_numberhash=hash then i did select userID where userID = $_GET['user'] registered = $_GET['hash'] (not exactly the sql phrase, but i dont feel like

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 database;

Re: [PHP] Why not @ ?

2005-03-22 Thread Marcus Joyce
mailto:[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, if you