Weblabor

 if ($formType == "query") {

	
	$activityresult[] = $db->query($db->select($activity_sql0)); // Fõcsoportok
	$activityresult[] = $db->query($db->select($activity_sql1)); // Alvállakozók
	$activityresult[] = $db->query($db->select($activity_sql2)); // Tevékenységek
	
	$form->smarty_addsqlselect("activityOptions1","activityValues1","name","activity_id",$activityresult[0]);
	$form->smarty_addsqlselect("activityOptions0","activityValues0","name","activity_id",$activityresult[1]);
	$form->smarty_addselect("categoryOptions","categoryValues",$categoryFieldValues);
		
	############ Build the javascript ###############
	$jscript .= "<SCRIPT lang=\"Javascript\">\n";
	
	$jscript .= "\tvar form = document.organization_query;\n";
	$jscript .= "\tvar namearray = new Array();\n";
	$jscript .= "\tvar activityarray = new Array();\n";
	$jscript .= "\tvar subactarray = new Array();\n";
	$i = 0;
	
	while (!$activityresult[2]->EOF) {
	
	    $jscript .= "\tnamearray[$i] = '".$activityresult[2]->fields["name"]."';\n";
	    $jscript .= "\tactivityarray[$i] = ".$activityresult[2]->fields["activity_id"].";\n";
	    $jscript .= "\tsubactarray[$i] = ".$activityresult[2]->fields["sub_activity_no"].";\n";
	    $i++;
	    $activityresult[2]->MoveNext();
	}
	
	$jscript .= "\tfunction changecat(option) {\n";
	$jscript .= "emptyList();";
	$jscript .= "\t\t for (var i=0; i<namearray.length;i++) {  \n";
	$jscript .= "if (activityarray[i] == option) {\n";
	$jscript .= "form.sub_activity_no.options[form.sub_activity_no.length] = new Option(namearray[i],subactarray[i]);\n";
	$jscript .= "form.sub_activity_no.selectedIndex=0;";
	$jscript .= "}\n";
	$jscript .= "}\n";
	$jscript .= "}\n";
	$jscript .= "function emptyList() { while ( form.sub_activity_no.options.length ) form.sub_activity_no.options[0] = null;}";	
	##############################################
	$jscript .= "</script>";
	$smarty->assign("jscript",$jscript);	
	$smarty->assign("org_type",$org_type);
	
    }