i want to create a referral system for MuOnline Website, i create new column in table MEMB_INFO with name referral, now i put in html file Referral field and in register function i add code for insert in database referral user like this:
,
but now i want to create a script like this:
if -> new user accont have TimeOnline(TimeOnline is a colum from MEMB_INFO) = 10 ("Update MEMB_CREDITS set credits = 100 WHERE memb___id='$referral'");
have some suggestion? how to create this?
PHP:
[B]$ref_usr[/B] = secure($_POST['[B]ref_usr[/B]']);
$a = mssql_query("INSERT INTO MEMB_INFO (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,fpas_ques,fpas_answ,[B]referral[/B]) VALUES ('$account','$password','$servername','1','$email','$date','$date','$date','$date','1','0','0','$question','$awnser','[B]$ref_usr'[/B])");
else
{
$a = mssql_query("INSERT INTO MEMB_INFO (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,fpas_ques,fpas_answ,[B]referral[/B]) VALUES ('$account',md5($password),'$servername','1','$email','$date','$date','$date','$date','1','0','0','$question','$awnser','[B]$ref_usr[/B]')");
but now i want to create a script like this:
if -> new user accont have TimeOnline(TimeOnline is a colum from MEMB_INFO) = 10 ("Update MEMB_CREDITS set credits = 100 WHERE memb___id='$referral'");
have some suggestion? how to create this?