I am using this code on a website and it seems to loop or take a while to load the data. I am certain it is my coding - can anyone tell me where my problem is? I would appreciate it. 😕
function display()
{
global $jscript,$conn,$config,$lang;
if (isset($_GET['pclass'][0]) && $_GET['pclass'][0] != '')
{
foreach ($_GET['pclass'] as $pclass => $id)
{
$sql = 'SELECT class_id FROM ' . $config['table_prefix'] . 'class WHERE class_id='.$id;
$rs=$conn->Execute($sql);
}
$jscript.='<script type="text/javascript" src="'.$config['baseurl'].'/addons/ajaxsearch/includes/xpath.js"></script>'."\r\n";
$jscript.='<script type="text/javascript" src="'.$config['baseurl'].'/addons/ajaxsearch/includes/SpryData.js"></script>'."\r\n";
$jscript.='<script type="text/javascript">'."\r\n";
if ($id < 21){
$jscript.='var dsCounties = new Spry.Data.XMLDataSet("'.$config['baseurl'].'/addons/ajaxsearch/data/countiesR/counties.xml", "counties/county");'."\r\n";
$jscript.='var dsLocations = new Spry.Data.XMLDataSet("'.$config['baseurl'].'/addons/ajaxsearch/data/countiesR/{dsCounties::url}", "county/locations/location");'."\r\n";
}
if ($id >= 21){
$jscript.='var dsCounties = new Spry.Data.XMLDataSet("'.$config['baseurl'].'/addons/ajaxsearch/data/countiesB/counties.xml", "counties/county");'."\r\n";
$jscript.='var dsLocations = new Spry.Data.XMLDataSet("'.$config['baseurl'].'/addons/ajaxsearch/data/countiesB/{dsCounties::url}", "county/locations/location");'."\r\n";
}
$jscript.='</script>'."\r\n";
$display.='<tr><td class="searchpage_field_caption">County:</td>';
$display.='<td align="left"><span spry:region="dsCounties" id="countySelector" class="SpryHiddenRegion">';
$display.='<select spry:repeatchildren="dsCounties" name="county" onchange="document.forms[0].location.disabled = true; dsCounties.setCurrentRow(this.selectedIndex);">';
$display.='<option spry:if="{ds_RowNumber} == 0" value="{value}" id="{ds_RowID}" selected="selected">{name}</option>';
$display.='<option spry:if="{ds_RowNumber} != 0" value="{value}" id="{ds_RowID}">{name}</option>';
$display.='</select>';
$display.='</span></td></tr>';
$display.='<tr><td class="searchpage_field_caption">Location:</td>';
$display.='<td align="left"><span spry:region="dsLocations" id="locationSelector" class="SpryHiddenRegion">';
$display.='<select spry:repeatchildren="dsLocations" name="location">';
$display.='<option spry:if="{ds_RowNumber} == 0" value="{name}" selected="selected">{name}</option>';
$display.='<option spry:if="{ds_RowNumber} != 0" value="{name}">{name}</option>';
$display.='</select>';
$display.='</span></td></tr>';
}
return $display;
}
?>
