if mysql record is admin, then run a code

[Ruko]

Hello, is there something like this?

 

If mysql record is admin, then a block of code

 

How do I do something like that

[Pikachu2000]

If you could just go ahead and clarify that, that would be great, ok?

[Ruko]

If an mysql value from a table is in a certain text (for example, in the users table, at the permissions column , it says "admin"), then run a block of code

[mikosiko]

If an mysql value from a table is in a certain text (for example, in the users table, at the permissions column , it says "admin"), then run a block of code

 

what code have you wrote already?....

[Ruko]

I didn't write any code, I can't seem to write it, how do I do this?

[fortnox007]

pen and pencil for starters : )

But I  assume you are trying to setup some sort of user level system where for instance unregistered have no level registered have level 1 and admins level 2.

 

Ones you have that you could make if-statements in your script that checks for a certain userlevel and if it does output stuff. Atleast that what i think you are looking for.

[Ruko]

$admin = mysql_query("SELECT level FROM users WHERE admin = '¥'") or die(mysql_error());

$array = mysql_fetch_assoc($admin);

 

if ($array['admin'] != '$nonadmins']) {

}

 

Hows that code?

 

Similar to deviantart usernames, for example, im the main admin, my username should be:

¥Ruko

 

[Ruko]

Bump, anyone want to correct my code?

[jcbones]

if ($array['level'] == 'admin']) {
//do this;
}
else {
//do that;
}

[Ruko]

Parse error: syntax error, unexpected ']' in /home/minivid/public_html/myart/index.php on line 23

[Ruko]

bump

[BizLab]

Hey Ruko, just a thought.. you will want to use numerics to represent different user levels.

 

regular user = 1

admin = 2

king_kong = 3

 

as far as the error goes, there is an extra "]" bracket in that code

if ($array['level'] == 'admin') {
//do this;
}
else {
//do that;
}

Other than that, his code will work just fine. I would prefer to use the $_POST[''] array to deal with the incoming data from the Db though as follows:

if ($_POST['level'] == 2) {
// you're the admin, go HERE and allow THIS
}
else {
// regular users GO here (use a header re-direct)
}