query($tblquerystatement); $therecord=$db->fetchArray($queryresult); $querystatement="SELECT ".stripslashes($displayfield)." as display, ".stripslashes($xtrafield)." as xtra "; if($thefield) $querystatement.=", ".$thefield." as thefield"; $querystatement.=" FROM ".$therecord["maintable"]." WHERE "; if($whereclause) $querystatement.=" (".stripslashes($whereclause).") AND "; $querystatement.=stripslashes($displayfield)." "; if($thefield) $querystatement.="=\"".$what."\""; else $querystatement.="LIKE \"".$what."%\""; $querystatement.="ORDER BY ".stripslashes($displayfield); if($thefield) $querystatement.=" LIMIT 1"; else $querystatement.=" LIMIT 10"; $queryresult=$db->query($querystatement); if(!$queryresult){ echo $querystatement; $numrows=0;die();} else { $numrows=$db->numRows($queryresult); } header('Content-Type: text/xml'); ?> '; ?> fetchArray($queryresult)) { ?> display extra thefield