Selecting records with two fields the same

D_tunisia

I have a table called "views" which looks like this:

page_id IP

1 10.10.10.10
2 192.162.1.1
3 127.0.0.0

When a user accesses one of my pages it records their IP address against the page they just viewed.

I am trying to write code that, before recording their IP, will look down this table and check to see if there is already an record which matches 1) The id of the page they are currently viewing and 2) Their IP address.

Thanks in advance for any help!

bough

you can just some kind of loop through the table to test each entry

$found = FALSE;
$userIP = $_SERVER['REMOTE_ADDR'];

$results = mysql_query("select ip from views");

foreach($results as $ip)
{
if($ip == $userIP)
{
$found = TRUE
break 2 // end if statement and foreach loop
}
}

if(!isset($found)
//insert new IP address

Roger_Ramjet

Simple query this


$sql = "SELECT * FROM table WHERE page_id=$page AND ip='$ip'":
$result=mysql_query($sql);
if (mysql_num_rows($result) == 0) {
   // do the insert
} else {
   // do the other thing
}

Now, the big problem with this is that ip addys are not tied to specific computers or people. Everyone here where I am is surfing through our proxy and your server will see the same IP, and at home they will be behind their ISPs proxy and probably gets a dynamic IP when they connect so their IP will vary. Bit difficult to track users when that is going on.

MAC addresses would work for tracking computers, except that there is no way to get at it through http. Java applet would work except that the user would have to allow your applet to execute and most people would not. Most people would view that as spyware and their desktop firewall should block that level of snooping anyway.