Hello,

I installed Chameleon and Easysocial (by Stackideas). I'd like set a php rule (Sql query) to apply a specific template style when user has selected some field value in his easysocial profile, for example "Green". Here is the structure of the table #_social_fields_data :
id
field_id
uid (id of user in joomla table)
type
datakey
data
params
raw

Please note that user must be logged in too, so i've just checked "All logged in" in Users and Groups tab.
I tried to set php rule below in Chameleon and i checked "true" in Default PHP return value. But it does not work.

if $user->uid > 0) {
  $data = Green;
  $query = "select uid from #_social_fields_data" where field_id = 72 and data = $data;
  $db->setQuery( $query );
  $yes = $db->loadResult();
  if ($yes) return true;
}


Help please.