How to know the previous url of my visitor

[BenySay]

Hi,
I'm using a little script to make some stats. I would like to add a command to know from where my visitor arrive ( url )
Any Ideas?
Here is the scripts ...

<?php

$browser = $HTTP_USER_AGENT ;

$ip = $REMOTE_ADDR ;
mysql_connect("localhost","username","passwd");

mysql_select_db("stats");

$sql01 =
"INSERT INTO stats_01 SET
ip = '$ip',browser = '$browser',received = SYSDATE()";

$results1 = mysql_query ( $sql01);

?>

[justageek]

$HTTP_REFERER - Tells you where they came from.
$PHP_SELF - Tells you what page they are currently on.

JAG

[BenySay]

$PHP_SELF work fine, so I don't see new entries for the $HTTP_REFERER command.
I can see what is wrong?

I changed my code for that :

<?php

$browser = $HTTP_USER_AGENT ;

$ip = $REMOTE_ADDR ;

$fromurl = $HTTP_REFERER ;

$inurl = $PHP_SELF ;

mysql_connect("localhost","username","passwd");

mysql_select_db("stats");

$sql01 =
"INSERT INTO stats_01 SET
ip = '$ip',browser = '$browser',received = SYSDATE(),fromurl = '$fromurl',inurl = '$inurl' ";
$results1 = mysql_query ( $sql01);

?>

[justageek]

$HTTP_REFERER is not 100 percent guaranteed to be there. You will see it sometimes and not others depending on browsers and such.

JAG

[mykel79]

Also, if you are using a firewall it might be blocking the referrer from being sent.