Set vars directly into SQL query is not a good choice (see [1]). You can set $user->uid as parameter and '%d' into SQL string. I'm not sure that's your error but you can try with this syntax.
Gwen
[1] http://api.drupal.org/api/function/db_query/5
Neil: esl-lounge.com wrote:
Hi,
this is put into a block code text box, with php code filter applied. Here is the whole block code:
<?php global $user; $result=db_query("SELECT content_type_nodeprofile.field_country_value, users_1.name, users_1.uid FROM ((users INNER JOIN content_type_nodeprofile ON users.uid = content_type_nodeprofile.field_uid_value) INNER JOIN content_type_nodeprofile AS content_type_nodeprofile_1 ON content_type_nodeprofile.field_country_value = content_type_nodeprofile_1.field_country_value) INNER JOIN users AS users_1 ON content_type_nodeprofile_1.field_uid_value = users_1.uid WHERE (((users.uid)=$user->uid) AND ((users_1.uid)<>$user->uid)) ORDER BY users_1.uid DESC LIMIT 5; "); while ($u = db_fetch_object($result)) { $items[]="<li class=\"member-list\">"; $items[]="<a class=\"members-link\" href=\"user/$u->uid\">$u->name</a>"; $items[]=" <a href=\"/search/user-search?filter1=$u->field_country_value\" class=\"geo-link\">$u->field_country_value</a>"; $items[]="</li>"; } return theme('front_page_geo_blocks', $items, "From my country"); ?>
is the problem the ordering of my filters for the php filter? Where would I need to place the html_entity_decode() to prevent the code getting mangled? I don't understand how the blocks are performing as per design if the code is getting altered? :-S
Thanks
Neil