hits

[NZ_Kiwi]

hey,

I have a gallerywhich has a view page and it has a code like this

select * from gallery where id =$id

and then

<img src="<? echo $row["pic url"}?>">

I want it to add a number to a a cell in my sql database every time the id of a picture is loaded...

[sid]

i suppose you mean something like a counter...

then add a field to your table:

hits, INT(11), default 0

and execute this query right after the select one:

UPDATE gallery 
SET hits = hits + 1
WHERE id = $id;

btw... it should be <? echo $row["pic url"]?> ;-)

[Tjeemp]

i wudn't use that, cause it will do that aswell when the same person goes there over and over again...

i made a seperate mysql table for it:

$ip = $REMOTE_ADDR;
mysql_pconnect("localhost", "$mysql_user", "$mysql_pass");
$gethits = mysql_db_query("$mysql_dbname", "select * from views WHERE imgid='$id' AND ip='$ip'");
if(mysql_num_rows($gethits) == 0) {
$ip = mysql_escape_string($ip);
$imgid = mysql_escape_string($imgid);
$link = mysql_pconnect("", "$mysql_user", "$mysql_pass")
or die("unable to connect to mysql server: ".mysql_error());
mysql_select_db('$mysql_dbname')
or die("unable to select database: ".mysql_error());
$query = mysql_query("INSERT INTO views (imgid, ip) VALUES ('$imgid', '$ip')", $link);
if (!$query) {
die("query failed: ".mysql_error());
}
}