Obtaining a single value.

[phrater]

Is anyone willing to share a howto for what ought to
be a simple PHP & MYsql function?

Here is what I want to do:

I have a TABLE called users in a DATABASE
called managed.

The table is made up of

username
firstname
lastname
permissions
colorscheme
password

I want $result to equal the value of permissions
WHERE username = joe and password = 4242

I don't want an array, just a single value.

To me (a newbie) this seems like it ought to be
incredibly simple, yet I cannot find the answer
in any of the MYsql or PHP documentation.

Any and All help is greatly appreciated.

[LordShryku]

$query = mysql_query("SELECT permissions 
                                      FROM users
                                      WHERE username = 'joe'
                                      AND password = '4242'");
$res = mysql_fetch_row($query);
$result = $res[0];

[philhale]

$res = mysql_fetch_row($query);
$result = $res[0];

--

I prefer something like this:

$res = mysql_fetch_array($query);
$result = $res["permissions"];

Only because it makes the code more "self documenting". Both solutions will work.