[FreshFroot]

So I have a small problem. I must be messing up somewhere.

I basically have a few variables, which gather some information from the "search" table.

One of those data variables is the "userid".

Now I stored this userid into a variable. And what I want to do is get the username.

So I am running the following query only to NOT get the username, but a resource code error. I assume I am missing something here.

 $mrs_user = $mrs_result["userid"]; 

 $the_username = "SELECT username FROM user WHERE userid = " . $mrs_user . "";

$mrs_username = mysql_query($the_username);

Then $mrs_username is called in a search resultbit template.

So what is it, that I am doing wrong here? I'm sure it's something stupid and yet simple.

I get an error of " Resource id #20" for where the username should be placed.

Thanks