help with msql_result

[chucklarge]

Hi,

I have a simple mysql db table named 'users'
inside 'users' i have
id----user---------pass-------level
1bob abc0
2joe____xye4
3tyler___3gtje0
4eno__iwjfidk_1

ok, so I will only need to get the 'level' from one user at a time. I know the 'user' at the time of the mysql call.

I am trying something like this, but i keep getting an error, so i know this is not correct

$user="bob";
$query = "SELECT level from users where user='$user'";
$result = mysql_result($query) or die ("Error in query: $query. " . mysql_error());
echo $result;

Any help with this is appreciated.
Chuck

[LarsLai]

hi!
try this. if it doesn`t work please post your error message

$result = mysql_result(mysql_query($query), 0) 
or die ("Error in query: $query. " . mysql_error());

[chucklarge]

Hi,
Sorry, that did not work. Here is the error.

Error in query: SELECT level from users where username='bob'.

I tried this as well

$result = mysql_result(mysql_query($query, 0))  

[LarsLai]

thats the error message from yourself. mysql_error() prints nothing?

i don`t know what can be wrong then...
have you established your database connection correctly
--> mysql_select_db()?

or you first try this and we will see if there`s a
problem with mysql_result() or something else.

$result=mysq_query($query);
$row = mysql_fetch_array($result);
echo $row[0];