Topic: How to check if the person is an admin?

[nakash]

Hey there, I'm new to MYSQL and PHP and I'd like to ask a few questions;
I have a database with 3 users and I want to check if that person is an administrator, I've already created the field 'Admin' in the database, but I don't know how to check it in the file.
I'm using a login system and it saves the session of his ID and the name.

Code: [Select]

$member = mysql_fetch_assoc($result);
$_SESSION['SESS_MEMBER_ID'] = $member['id'];
$_SESSION['SESS_FIRST_NAME'] = $member['Name'];
Is there a way to check if that specific person is an admin?
Thanks in advance.

[nakash]

Hey there, I'm new to MYSQL and PHP and I'd like to ask a few questions;
I have a database with 3 users and I want to check if that person is an administrator, I've already created the field 'Admin' in the database, but I don't know how to check it in the file.
I'm using a login system and it saves the session of his ID and the name.

Code: [Select]

$member = mysql_fetch_assoc($result);
$_SESSION['SESS_MEMBER_ID'] = $member['id'];
$_SESSION['SESS_FIRST_NAME'] = $member['Name'];
Is there a way to check if that specific person is an admin?
Thanks in advance.

Sorry for doubleposting, but I couldn't edit this message.

My second question is how do I do change a field of someone using his ID? ('id')
I know it's something with UPDATE ;p

[fenway]

Sounds like you're asking how to use a database.

[James25]

but what is the problem?

[nakash]

Sounds like you're asking how to use a database.

Oh.. nonono lol.
I forgot to mention that I need those to be scripted in PHP.

[fenway]

Sounds like you're asking how to use a database.

Oh.. nonono lol.
I forgot to mention that I need those to be scripted in PHP.

Right -- so you're asking how to query a database with PHP.