Hiding Rank 8

[Wolverine]

I want to create a 'hidden' table under 'users' where on the staff page, it wont display that user on the staff page but they'll still be rank 8. Possible?

Staff.php:

You must be registered for see links

 

[JayC]

$GetUsers = mysql_query("SELECT username,motto,rank,last_online,online,look FROM users WHERE rank = {$Ranks['id']} ORDER by id");

Add a column in the users table called "staff_hide" and make it an int length 11 , 0 (Alternatively, use an ENUM variable if you only want 1 and 0)

then just change the top code to this:

$GetUsers = mysql_query("SELECT username,motto,rank,last_online,online,look FROM users WHERE rank = {$Ranks['id']} AND staff_hide = '0' ORDER by id");

Set staff_hide to 1 to hide them from the page.

 

[Ecko]

$GetUsers = mysql_query("SELECT username,motto,rank,last_online,online,look FROM users WHERE rank = {$Ranks['id']} ORDER by id");

Add a column in the users table called "staff_hide" and make it an int length 11 , 0 (Alternatively, use an ENUM variable if you only want 1 and 0)

then just change the top code to this:

$GetUsers = mysql_query("SELECT username,motto,rank,last_online,online,look FROM users WHERE rank = {$Ranks['id']} AND staff_hide = '0' ORDER by id");

Set staff_hide to 1 to hide them from the page.

wtf that's so excessive, just change this query:

$GetRanks = mysql_query("SELECT id,name,tab_colour,title FROM ranks WHERE id > 1 ORDER BY id DESC");

to

$GetRanks = mysql_query("SELECT id,name,tab_colour,title FROM ranks WHERE id > '1' AND id < '8' ORDER BY id DESC");