ID user in query field

Hello

I have an external database where i stock score of player. Actually I display score with
this sql request

SELECT bestscore FROM score WHERE numplayer= :numplayer AND numtheme= :themeselect'


the variable numplayer is session variable :
$user =& JFactory::getUser();
$numplayer = $user->id;

I would like create a query field with this sql request. Can I do it ?

Thanks

CB Query Field supports substitutions and you can substitute in the user id using [user_id]. Example as follows.

Thanks for your response !

Do you know where i can find documentation on query field ?

I have difficult with multirow output, and i would like read documentation before ask question on this forum

Do you know where i can find documentation on query field ?

There isn't any.

I have difficult with multirow output, and i would like read documentation before ask question on this forum

Please be sure to review the info icons carefully and if you've any further questions then feel free to ask.