[SOLVED] PHP not Updaing MySQL record

[tjverge]

<?php

 

$dbcnx = @mysql_connect("localhost", "***", "*********");;if (!$dbcnx) {  echo(

 

"<P>Unable to connect to the " .        "database server at this time.</P>" );  exit

 

();}

 

if (! @mysql_select_db("pop") ) {

echo( "<P>Unable to locate the " .

"database at this time.</P>" );

exit();

}

 

 

$result = mysql_query("SELECT * FROM clicks");

mysql_query('UPDATE count SET count = count + 1');

 

$countgame = mysql_num_rows($result);

echo 'there are, ', $countgame, ' games in our system ';

 

 

php?>

 

 

I use the above code to update the vistor count but the record in mysql does not go up just stays at 0, any ideas?

 

Thank you

[pocobueno1388]

Okay, so it's this line we are looking at

mysql_query('UPDATE count SET count = count + 1');

 

The first thing I notice is that you specify the tables name as "count", and also the field name as "count". Are you sure the tables name is "count"?

 

Your syntax should be like this

mysql_query('UPDATE TABLE_NAME SET count = count + 1');

 

Also, you have no WHERE clause. So your query is going to update EVERY records "count" field +1, is that what you want?

[tjverge]

that fixed it I was using the wrong table name thank you. as for the where clause for now I will only have the one record in the table, but will keep it in mind if there is going to be more then one record.

 

Thank you again.

[tjverge]

ok was working fine until I tried to add a WHERE clause:

 

$pagename = 'test';

$result = mysql_query("SELECT * FROM clicks");

mysql_query ('UPDATE clicks SET count = count + 1 WHERE pagename=$pagename');

 

will update with out the WHERE clause, any ideas on how to make it work with the clause.

 

Thank you,

[webent]

ok was working fine until I tried to add a WHERE clause:

 

$pagename = 'test';

$result = mysql_query("SELECT * FROM clicks");

mysql_query ('UPDATE clicks SET count = count + 1 WHERE pagename=$pagename');

 

will update with out the WHERE clause, any ideas on how to make it work with the clause.

 

Thank you,

 

Try ...

mysql_query ("UPDATE clicks SET count = count + 1 WHERE pagename='$pagename'");

[tjverge]

works perfect, thank you for the help