"id"]; $strSQL = "SELECT id FROM ".CLUB_USERS_TABLE." WHERE id_club='".$clubs[$i]["id"]."' AND id_user='".$id_user."' " ; $rs_c = $dbconn->Execute($strSQL); if ($rs_c->fields[0]>0){ $clubs[$i]["user_in_club"] = 1; } else { $clubs[$i]["user_in_club"] = 0; } $rs->MoveNext(); $i++; } $smarty->assign("clubs", $clubs); } else { $smarty->assign("clubs", 'empty'); } return ; } ?>