MySQL , PHP : Hide specific Value from table

Question

I am working on a ' Show Online user' script where the script show everybody who is online. Now i want to remve the entry which matches the session user name i.e "if (Online user = Session User name ) then do not display it , just like on facebook.com chat where your friends id is shown and not your own Id my code is as follows :

    <?php
    mysql_connect("localhost","root","12345");
    mysql_select_db("accounts");
    $user = $_SESSION['user_name'];
    $result = mysql_query("SELECT * FROM online * WHERE ($chat<>$user)");

    while($row=mysql_fetch_array($result)) {
      $chat=$row["emp_name"];
      $chlk = ("<a href=javascript:void(0) onclick=javascript:chatWith('$chat')>$chat</a>");
      $chs = ("<a>$chat</a>");
      if ($chat <> $user) {
      echo $chlk;
      }
      else {
      echo $chs;
      }
   echo $chlk;
}
?>

I am getting the following error :

Notice: Undefined variable: chat in localhost/accounts/removeuser.php on line 7

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given localhost/accounts/removeuser.php on line 9

Any help is highly appreciated.

make sure $result does not have boolean....share code for $result — Dipesh Parmar
– Dipesh Parmar, Commented Mar 23, 2013 at 11:46

Dipesh Parmar · Accepted Answer · 2013-03-23 11:49:26Z

2

Correction in query.

"SELECT * FROM online WHERE ($chat<>$user)"

OR

Replace $chat in query with your table field name.

there is extra * before WHERE that is invalid.

and $chat is not defined in query.

answered Mar 23, 2013 at 11:49

Dipesh Parmar

27.3k8 gold badges65 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Aaditya Chakravarty Over a year ago

i tried the correction but the script still gives the same error , could you recommend a script where all users are show except the user which is viewing the list ?

Dipesh Parmar Over a year ago

"SELECT * FROM online WHERE username != '".$_SESSION['loggedInUser']."'"

Aaditya Chakravarty Over a year ago

thanx i got it , but not the way you told , i used not like .. ` SELECT * FROM online WHERE emp_name NOT LIKE '%$user%'"`

Dipesh Parmar Over a year ago

@AadityaChakravarty well even emp_name != '$user'" also work..because if you have aaditya and aadit in table then both not selected so use != is best to eliminate exact user.

Svish · Accepted Answer · 2013-03-23 11:49:39Z

0

<> is not PHP as far as I know. You need to use !==.

(and probably read up on some PHP basics...)

answered Mar 23, 2013 at 11:49

Svish

159k183 gold badges479 silver badges636 bronze badges

Collectives™ on Stack Overflow

MySQL , PHP : Hide specific Value from table

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related