$RS = $Conn->Execute("SELECT * FROM affiliate where Affiliate_Number=".$an);
$RS -> movelast;
$RS -> movefirst;
$RS -> Recordcount;
if( $RS->Recordcount = 0 ) { 

		&error('bad_affiliate_number');

        }

        else {


$sql="update affiliate set Affiliate_Refferals=Affiliate_Refferals+1 where Affiliate_Number=".$an;


$Conn->Execute($sql);