更改数据库中的标志以显示某人“在线”，但它无法正常工作

Question

Here is a little breakdown of whats going on

The biggest problem I have right now is, in login.php, it is supposed to change a flag in the database to show a person is online.

if($table=='chatmodels'){
              $sql="update ".$table." set loginStatus=1 where user=".$id['user'];
$upd=mysql_query($sql);

It should change 'chatmodels.loginStatus' to equal 1 once a person successfully logs in, but it doesn't work. It used to work.

I'm pretty sure the I have something wrong in the database configuration.

Here is a screenshot of my database http://i.stack.imgur.com/BcaII.jpg

Answer 1

From the screen shot, I see that the chatmodels table resides in the qoc1 database.

Since you are using php, you need to do one of two things:

Option 1 : Use mysql_select_db as follows:

mysql_select_db('qoc1'); before calling for the update query

if($table=='chatmodels'){ 
          mysql_select_db('qoc1');
          $sql="update ".$table." set loginStatus=1 where user=".$id['user']; 
$upd=mysql_query($sql); 

Option 2 : Put qoc1 into the query itself:

if($table=='chatmodels'){ 
          $sql="update qoc1.".$table." set loginStatus=1 where user=".$id['user']; 
$upd=mysql_query($sql); 

Give it a Try !!!

Other things to remember

• If the table is MyISAM, it should run immediately
• If the table is InnoDB, make sure autocommit = 1

UPDATE 2011-12-15 15:28 EDT

Try putting 'or die' after the $upd=mysql_query($sql); and see what mysql-based error message comes back