[RESOLVED] Counter code problem

[XIII]

This is a counter code i'm trying to make which is recording in a database:

<?php
$conn = mysql_connect("localhost","db_username","db_pssword") or die('MySQL said:  ' . mysql_error());
$db = mysql_select_db("db_name");
$sql = mysql_query("SELECT * FROM counter") or die('MySQL said:  ' . mysql_error());

while($visits = mysql_fetch_array($sql))
{
$visits = $visits["visits"];
$visits_new = $visits + 1;
}


$query = "UPDATE TABLE counter SET visits = $visits_new ";
mysql_query($query, $conn) or die(mysql_error());

echo ("visits : $visits_new");
?>

but it always giving me this error:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE counter SET visits =' at line 1

i tried alot with it but never got a result.
P.S: ofcourse the table name is counter and the field name is visits

[Houdini]

$query = "UPDATE TABLE counter SET visits = '$visits_new' ";

[XIII]

Houdini wrote:

$query = "UPDATE TABLE counter SET visits = '$visits_new' ";

The error message just changed a little 😕

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE counter SET visits = ''' at line 1

[Houdini]

Why not just do this

$conn = mysql_connect("localhost","db_username","db_pssword") or die('MySQL said:  ' . mysql_error());
$db = mysql_select_db("db_name");
$result = mysql_query("SELECT * FROM counter", $conn);
$num_rows = mysql_num_rows($result);
echo "$num_rows Hits\n";

[XIII]

This will not insert any data into the database, it will always say 0 Hits

WOW, i found a solution:

$conn = mysql_connect("localhost","username","password") or die('MySQL said:  ' . mysql_error());
$db = mysql_select_db("db_name");
$sql = mysql_query("SELECT * FROM counter") or die('MySQL said:  ' . mysql_error());
while($visits = mysql_fetch_array($sql))
{
$visits = $visits['visits'];
$visits_new = $visits + 1;
}

$query = "UPDATE counter SET visits = '$visits_new'";
mysql_query($query, $conn) or die(mysql_error());

echo "$visits_new Visits";

i removed TABLE from:
$query = "UPDATE TABLE counter SET visits = '$visits_new'";
and don't forget to set the visits value in the database to zero or any number you want, just don't leave it as default.

[Houdini]

That makes sense, I completely overlooked it, glad you found it, just remember to quote your varibles in single quotes.