PDA

View Full Version : Dual registrations


22nd February 2005, 01:58 PM
I have just installed the post affiliate script, and created an affiliate account to test to make sure everything was working. The script is not preventing multiple users from having the same ID. I recieve the following error message when signing up
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/turnkey/public_html/user/signup.php on line 22

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/turnkey/public_html/user/signup.php on line 23
line 22 and 23 are :
$chk_user = mysql_query(turnkey_affiliate, "select refid from affiliates where refid='$userid'");
Everything else is working fine, it tracks click throughs and sales, but I would like to correct this error so I do not have 2 individuals sign up with the same ID
Thank you for your help