I'm looking for a PHP Referral system for my site

I want to add a referral system to my membership site that saves cookies.

Where the steps go like this:

Registration

>>

Member info. entered in database, and referral link given out like  mysite.com/ref.php?id=xxx

>>

Page has sql/php coding which then adds +1 in the users referral row.

I found this code

<?php

include("connect.php"); //make sure we connect to the database first

$user = $_GET['user'];

if(!$user){

//echo out site normally

} else {

$sql = mysql_query("SELECT * FROM members WHERE user='$user' LIMIT 1");

$row = mysql_fetch_array($sql);

$referal = $row['users_referals']; //Get whats in that field

$referaladd = $referal +1; //I am not sure on this as ive not used math operators in php before, but basically your adding one onto whats in the db

$add = mysql_query("UPDATE members SET users_referals = '$referaladd' WHERE user = '$user'"); //Update the db with the users referals

echo "You were refered by $user";

//echo out rest of the site

}

?>

Does this help?

replace this

$referaladd = $referal +1; //I am not sure on this as ive not used math operators in php before, but basically your adding one onto whats in the db

$add = mysql_query("UPDATE members SET users_referals = '$referaladd' WHERE user = '$user'"); //Update the db with the users referals

with

$add = mysql_query("UPDATE members SET users_referals = users_referals+1 WHERE user = '$user'"); //Update the db with the users referals