[SOLVED] Hits?

[tomtom]

Hey. I've done it a million times before but it just doesn't seem to work this time.

 

I've made a VERY simple script to update the amount of hits a page has had in mysql. I've set the attribute `hits` to INT.

 

Here's my code. The weird thing is...it'll update the page the first time, from 0 to 1. But then it won't go any higher than 1.

 

<?php
$get_home = mysql_query("SELECT * from `pages`");
while($home = mysql_fetch_array($get_home)) {
    $hits = $home[hits]+1;
    $update = mysql_query("UPDATE `pages` SET `hits` = '" . $hits . "' WHERE `id` = '$home[id]'");
}
?>

[ILYAS415]

instead of

$update = mysql_query("UPDATE `pages` SET `hits` = '" . $hits . "' WHERE `id` = '$home[id]'");

 

try using...

$update = mysql_query("UPDATE `pages` SET `hits`='$hits' WHERE `id` = '$home[id]'");

[thebadbad]

You should quote your array keys, since they are strings. $home['hits'] and $home['id'], but not sure it will change any functionality.

[tomtom]

Nice try, but nope...didnt work

[DarkWater]

mysql_query("UPDATE pages SET hits=hits+1 WHERE id = {$home['id']}") OR die(mysql_error());

[tomtom]

Cheers matey