Using GET method

[winsonlee]

Assume that i have an url eg

http://www.temp.com/register.php?refferal=justin

how can i get the string name "justin" from the refferal and compare it in the database and see if the refferal name exist in the database ??? I am using mysql for my database type.

If the refferal name exist in the database, then it will display "account valid" on the screen. Otherwise it will display "account invalid"

[kevinsequeira]

$refferal = $_GET['refferal'];

// set up your database connections
// write the query eg 
$query = "select * from refferal_table where refferal_name = '".$refferal."'";
$result = mysql_query($query);
if(mysql_error())
 echo mysql_error();
if(mysql_num_rows($result) > 0)
 echo "valid";
else
 echo "invalid";

reg
kevin