tjverge Posted June 8, 2008 Share Posted June 8, 2008 <?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. Quote Link to comment https://forums.phpfreaks.com/topic/109268-solved-mysql-not-updating-record/ Share on other sites More sharing options...
tjverge Posted June 8, 2008 Author Share Posted June 8, 2008 wrong forum sorry Quote Link to comment https://forums.phpfreaks.com/topic/109268-solved-mysql-not-updating-record/#findComment-560470 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.