need help getting variable from query

[krispykreme]

$userinfo = mysql_fetch_array(mysql_query("select $tab[pimp].*,users.signature from $tab[pimp] join users on $tab[pimp].code = users.code WHERE $tab[pimp].id=$threadinfo[user_id];"));

 

 

$puser = "$userinfo[pimp]"; //this works

$posts = "$userinfo[posts]"; //this works

$avatar = "$userinfo[avatar]"; // this works

 

$signature = "$userinfo[signature]"; // this doesnt

 

 

So how can i get this from it?  In the database it is a TEXT variable if that makes a difference..

 

this is the first time ive used a JOIN

 

 

 

[DeanWhitehouse]

is the field name correct?

and/or try

$signature = $userinfo['signature']; // this doesnt