[andyinorbit2000]

I have a script that records hits into a MySQL db using:

PHP Code:

mysql_db_query($database, "INSERT INTO sales VALUES ('$ref', '$clientdate', '$clienttime', '$clientbrowser', 
'$clientip', '$payment', '$clienturl')") 
    or die("Database INSERT Error (line 34)"); 


However I need the script to check to see if the $ref value AND $clientdate value AND $clientip value are the same, if so dont store.

This way hits sent from the same reffer and using the IP address on the same day or not recorded in the db.

Any ideas?
If you would like to chat about this or would like any more info please email me at andyinorbit2000@yahoo.com


Thanks for any help you can give.
Andy

[SleeperZ]

$today = (todays date);

if (($ref == $clientip) && ($clientdate == $today))
{
//Do not store
}

else
{
//run sql query
}

Pretty basic example, but I am guessing that is what your asking?

/SleeperZ