Имам код:
<?php
$server="localhost";
$user="";
$pass="";
$db="ref";
mysql_connect($server, $user, $pass);
mysql_select_db($db);
$idva = $_SERVER['HTTP_REFERER'];
if($idva == '') {
$ip = $_SERVER['REMOTE_ADDR'];
$date = date("j.n.Y");
$query ="INSERT INTO ref(`id`, `url` ...