I am trying to capture the website's name that links to my website. When a person clicks that link, it should add it to my database. For some reason though, it isn't working. Any suggestions?

<?php
include('inc/connect.php');

$today = date("Y-m-d");
$ip = $_SERVER['REMOTE_ADDR'];
$referrer = getenv('HTTP_REFERER');
$referrerfinal = parse_url($url, PHP_URL_HOST);

echo $referrerfinal;
$check = mysql_query("SELECT * FROM uniquevisitors WHERE ip='$ip'");
$unique = mysql_num_rows($check);
if ($unique==0)
{
  $insert = mysql_query("INSERT INTO uniquevisitors VALUES ('',now(),'$ip','$referrerfinal')");
}
else
{
  exit();
}

?>

Database:

countid      int(11)       No                
date     datetime     No      0000-00-00 00:00:00       
ip     varchar(20)     No             
referrer     varchar(255)     No

Thanks

Replace exit() with mysql_error() to see what's wrong with your query.

Lol, wrong.

if (!$insert)
print(mysql_error());

Also it is very inefficient to store IP addresses as 20 bytes varchar since it can be stored as 4 bytes int and easily converted between int and string with ip2long() and long2ip() functions respectively.

Tried adding the code to check for any errors, and it returns nothing. I've been told that http_referer doesn't store the value very well. not sure what to do to get it to work.

So the problem is that your query fails while being executed or is not executed at all due to condition that is never true? Or how exactly does it "not work"?

It does not input the value (referrals) into the database. that is what is supposed to be working, but it isn't.