can someone help me I have a little problem so…my problem is :
I created a page views counter but I do not know how to limit based on ip,because when i refresh the page the page view grows . my db table look like this:
<!—This is pageviews table–called (pagine)-!>
| id |
| pageid |
| pagename |
| views |
| ip |
and here is my code :->
<?php
if (isset($_GET[“id”])) {
$id = $
}
mysql_select_db($database_filminitaliano, $filminitaliano);
$query_lista_pagine = sprintf(“UPDATE pagine SET views = views+1 WHERE pagine.pageid = %s” , GetSQLValueString($id, “int”) );
$lista_pagine = mysql_query($query_lista_pagine, $filminitaliano) or die(mysql_error());
$query_Lista_pagine = sprintf(“SELECT * FROM pagine WHERE pagine.pageid = %s ” , GetSQLValueString($id, “int”));
$lista_pagine = mysql_query($query_Lista_pagine, $filminitaliano) or die(mysql_error());
$Row_Lista_pagine = mysql_fetch_assoc($lista_pagine);
$TotalRows_Lista_pagine = mysql_num_rows($lista_pagine);
//finiamto!
?>
Can sombody give me a hand please tnks