如何使用sql隐藏表中的特定行

问题描述：

I want to show all data from "employee" table except the details of user which is logged in?

eg:

EMP_ID | EMP_Name

  1    |  Mike
  2    |  Peter
  3    |  Drake
  4    |  Oliver
  5    |  Andrew

Suppose, my current login user is "Peter" whose EMP_ID is 2, so I want to show table like this...

EMP_ID | EMP_Name

  1    |  Mike
  3    |  Drake
  4    |  Oliver
  5    |  Andrew

Basically I want to hide the details from table of current user. Please help me how to achieve it??

我想显示“employee”表中的所有数据，但登录用户的详细信息除外？ p >

例如： p>

EMP_ID | EMP_Name p>

  1 | 迈克
 2 | 彼得
 3 | 德雷克
 4 | 奥利弗
 5 |  Andrew 
  code>  pre> 
 
 假设，我当前的登录用户是“Peter”，其EMP_ID是2，所以我想要显示这样的表......  p> 
  
 
 EMP_ID |  EMP_Name  p> 
 
 
  1 | 迈克
 3 | 德雷克
 4 | 奥利弗
 5 |  Andrew 
  code>  pre> 
 
 基本上我想隐藏当前用户表格中的详细信息。 请帮我怎样实现它？ p> 
  div>

答

Essentially you have to select everything you want and eliminate what you don't want:

SELECT *
FROM `employees`
WHERE `EMP_ID` != 2; -- eliminates Peter

答

 $query = "select EMP_ID, EMP_Name from EMPLOYEES where EMP_ID <> $emp_log";

I think that you know who is log by using a session var, so the var $emp_log must be get from the session var, ex.

 $emp_log = $_SESSION['emp'];

如何使用sql隐藏表中的特定行

相关推荐