How not to display admin when fetching data from mysql user table

[malkocoglu]

Dear users,

 

I am trying to disregard ADMIN when displaying registered users from USERS table.

 

The code I am using is

if($session->isAdmin()) {$query="SELECT username FROM users ";}

This gives me all the users from the database. What I want to do is not to display ADMIn and display the rest of the users.

 

is it possible? Could anyone help?

[Jessica]

Use a WHERE clause on your query.

[mac_gyver]

you would add a WHERE term to your query that either excludes the admins or selects everyone but admins, whichever is easier to do.

 

edit, lol, see the above reply by jessica.

Edited May 14, 2013 by mac_gyver

[malkocoglu]

Thanks for quick replies. Could you possible wrote the code where it excludes the ADMIN?

[Psycho]

Thanks for quick replies. Could you possible wrote the code where it excludes the ADMIN?

 

No, because we have no idea what you may, or may not, have in your database to identify what an ADMIN is.

 

Do you have a column called "admin" with a 0/1 value?

 

SELECT username FROM users WHERE admin = 0

[malkocoglu]

Ok. what I have is a table called users and in that table there are the following;

 

username

password

userid

userlevel

email

timestamp

 

Admin doesn not have a value

 

 

[davidannis]

try

if($session->isAdmin()) {$query="SELECT username FROM users WHERE `username` !=' ADMIN' ";}

[malkocoglu]

 

try

if($session->isAdmin()) {$query="SELECT username FROM users WHERE `username` !=' ADMIN' ";}

 Thanks for the reply but it didnt work..

[malkocoglu]

I have realised that the user names are lowercase, it worked After changing the ADMIN to admin.

 

Thanks a lot