My SQL counter

5rent

I am trying to add code to bottom of webpage that will update mysql database with each new visitor. I have set up a mysql DB with table named 'webpage' and column 101 is called 'count'.
Each row in the table is a different webpage ($id=1508)

I am not sure why the below code will not increment the 'count' column for $id=1508 by 1. Please help.

<?php
$id = '1508';
$DBhost = 'address';
$DBuser = 'user';
$DBpass = 'pass';
$DBName = 'name';
mysql_connect($DBhost,$DBuser,$DBpass) or die('Unable to connect to database');
@mysql_select_db('$DBName') or die('Unable to select database $DBName');
$sqlquery = '(UPDATE webpage SET count=(count+1) where id=$id');
mysql_close();"
?>

laserlight

There's a PHP syntax error in your declaration of $sqlquery
You did not actually run mysql_query() on $sqlquery.

5rent

Thanks laserlight.
I will try to debug and look at the mysql query more closely.

5rent

OK tried laserlights ideas but my code is still not working.

My echo statement is displaying but the count column in mysql db is not incrementing yet

The below code diplays:
your 1508 webpage should counter should have updated 1

Any help is appriciated.

<?php
$DBhost = "host";
$DBuser = "user";
$DBpass = "pass";
$DBName = "name";
$id = "1508";
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");
$sqlquery = "UPDATE webpage SET count=(count+1) WHERE id = '$id'";
$sqlquery = "SELECT * FROM webpage WHERE id = '$id'";
$result=mysql_query($sqlquery);
$row=mysql_fetch_row($result);
mysql_close();
echo "your 1508 webpage should counter should have updated $row[101]";
?>

laserlight

Try testing with:

<?php
$DBhost = "host";
$DBuser = "user";
$DBpass = "pass";
$DBName = "name";
$id = "1508";
mysql_connect($DBhost,$DBuser,$DBpass)
	OR die("Unable to connect to database");
mysql_select_db("$DBName")
	OR die("Unable to select database $DBName");
$query = "UPDATE webpage SET count=(count+1) WHERE id='$id'";
mysql_query($query)
	OR die(mysql_error());
$query = "SELECT count FROM webpage WHERE id='$id'";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
echo "The new count is " . $row['count'];
?>

5rent

Thanks laserlight.

It worked like a champ. My counter in now incrementing with every page hit.

It is great that you and so many others are spending time in here helping us that are not so good programmers., and you ask for nothing in return.

The world aint so bad afterall.
thanks