Check value in sql and report back

[jample]

Question for a newb ...

I want to issue a query via php, and report back if the value of the query is yes or no ...

The table name is: user

the field holding the value in this table is: settings

The value is 0 or 1 or 2 or 3, 0 being the default value.

The table user, has multiple fields, one of which holds the users id #, it being userid.

So what we need to do, is send the query, which includes the userid, so we can verify the value we're looking for in settings is in fact his, and report back what the setting value is.

IE:

$result=mysql_query("SELECT * FROM user WHERE userid=$bbuserinfo[userid] AND this is where im lost);

If the field: settings is 0 i want to assign a value, say:

$settings = 0

If the field: settings is 1 i want to assign a value, say:

$settings = 1

the same etc etc for 2 and 3 ...

Any assistance is appreciated!! <extreme n00b>

[devinemke]

mysql_connect('host', 'username', 'password');
mysql_select_db('database');

$result = mysql_query("SELECT settings FROM user WHERE userid = '" . $bbuserinfo['userid'] . '"');
if (!$result) {exit(mysql_error());}
$settings = mysql_result($result, 0);
echo $settings;