Counting Problem

imri

I'm trying to add 1 to a counter everytime that the page is loaded.
This is my function code:

function FileWrite($sign, $act, $id) {
  include("./Configs/Config.php");


  $action = array('Plus' => '+','Minus' => '-');
  if (!mysql_query("UPDATE Text SET $act = $act{$action[$sign]}1 WHERE id = '$id'")) {
    return false;
  }
  if (!mysql_query("UPDATE Total SET $act = $act{$action[$sign]}1")) {
    return false;
  }
  return true;
}

It is counting well, but sometimes it just going crazy.
like here:

http://img510.imageshack.us/img510/161/screenshotoi8.jpg

What can i do to solve it?
It's very urgent. Thanks!

Horizon88

There's probably a way you can do this with just mysql - I'm always surprised when I need to write some php code and weed or nogdog come in and do it with a single sql query. 😃 It looks to me like you're referencing $action - where does this come from/what is it? And why is there a '1' after $sign]} ?

cahva

Heh it is done with just mysql 🙂 As I can see, for example when using function like this:
FileWrite('Plus', 'somefield', 12);

..would create this:

mysql_query("UPDATE Text SET somefield = somefield+1 WHERE id = '12'")

..and that seems fine to me.

@:
Is the number also that high in the database(you said in the screenshot that it should be 50-100, not around 5000) or is it that high only when you echo it?

imri

Also in the database.
What can i do? 😕

jkurrle

Make a table called count1. Have one column called counter, which is an integer, (or big_int). Set it initially to zero. Then do the following code:

//make your server connection and assign it to a variable like $connection
//Then select your database
$update="update count1 set counter=counter+1";
$result=mysql_query($update);
mysql_close($connection);

See if that works.