100 credits to the one who fix this php

[galaxyAbstractor]

Soooo something is wrong again...

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect to server ");
mysql_select_db("$db_name")or die("cannot select DB")

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
$counter=$rows['counter'];

// if have no counter value set counter = 1
if(empty($counter)){
$counter=1;
$sql1="INSERT INTO $tbl_name(counter) VALUES('$counter')";
$result1=mysql_query($sql1);
}

echo $counter;
echo "people has played our games. ";


mysql_close();
?>

I get this error: Parse error: syntax error, unexpected T_VARIABLE in /home/viggeswe/public_html/flash/counterh.php on line 12

Line 12 is

$sql="SELECT * FROM $tbl_name";

It isn't line 12 here because I deleted the password and username thing at the top.

And yes. Everything I had input in the code is correct. And I have deleted the add hit on this one because I want to count the game plays and not the main page hits.
Edit:
Ok I give 100 credits for the one who fix it

 

[supajason]

you need a table name?

line 11

$tbl_name = "table name";

 

[galaxyAbstractor]

I sad I already had done that but I don't want to post all my database password etc. The table name is there. Btw, this is what I use:

$tbl_name="counter"; // Table name

And I have created the table.

 

[supajason]

post the whole file please?

 

[galaxyAbstractor]

<title>Untitled Document</title><?php
$host="localhost"; // Host name
$username="*deleted*"; // Mysql username
$password="*deleted*"; // Mysql password
$db_name="viggeswe_phpbb"; // Database name
$tbl_name="counter"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect to server ");
mysql_select_db("$db_name")or die("cannot select DB")

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
$counter=$rows['counter'];

// if have no counter value set counter = 1
if(empty($counter)){
$counter=1;
$sql1="INSERT INTO $tbl_name(counter) VALUES('$counter')";
$result1=mysql_query($sql1);
}

echo $counter;
echo "people has played our games. ";

mysql_close();
?>

 

[supajason]

change

mysql_select_db("$db_name")or die("cannot select DB")

to

mysql_select_db("$db_name")or die("cannot select DB");

 

[galaxyAbstractor]

Ok, It worked now. I give you the credits if you fix this too:

<title>Untitled Document</title><?php
$host="localhost"; // Host name
$username="************"; // Mysql username
$password="************"; // Mysql password
$db_name="viggeswe_phpbb"; // Database name
$tbl_name="counter"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect to server ");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
$counter=$rows['counter'];

// if have no counter value set counter = 1
if(empty($counter)){
$counter=1;
$sql1="INSERT INTO $tbl_name(counter) VALUES('$counter')";
$result1=mysql_query($sql1);
}

// count more value
$addcounter=$counter+1;
$sql2="update $tbl_name set counter='$addcounter'";
$result2=mysql_query($sql2);

mysql_close();
?>

It adds 2 instead of 1 when I visit the page once.

 

[supajason]

try

$addcounter = $counter + "1";

or

$counter++;
$sql2="update $tbl_name set counter='$counter'";

 

[galaxyAbstractor]

Yey!!! Thank you very much!