MYSQL Select query and PHP IF statement to build custom dropdown element

[troester]

I can't replicate this.
Using exactly your code (from post#1) in a default eval the var_dump gives me
string(154) "SELECT cb_scoutgroup FROM j16bpsa_comprofiler INNER JOIN j16bpsa_users ON j16bpsa_comprofiler.id=j16bpsa_users.id WHERE ( `username` ='superad' ) "

But glad you got it working with JFactory::getUser();