query($querystatement);
$therecord=$db->fetchArray($queryresult);
echo $therecord["sqlclause"];
}
function deleteSavedSort($id,$db){
$querystatement="DELETE FROM usersearches
WHERE id=".((int) $id);
$queryresult = $db->query($querystatement);
echo "success";
}
function displaySavedSortList($queryresult,$db){
$numrows=$db->numRows($queryresult);
?>
query($querystatement);
?>
query($querystatement);
echo "success";
}
function showSort($tabledefid,$basepath,$db){
//First, grab table name from id
$querystatement="SELECT querytable FROM tabledefs WHERE id=".$tabledefid;
$queryresult = $db->query($querystatement);
if(!$queryresult) $error = new appError(500,"Cannot retrieve Table Information");
$thetabledef=$db->fetchArray($queryresult);
//Grab query for all columns
$querystatement="SELECT * FROM ".$thetabledef["querytable"]." LIMIT 1";
$queryresult = $db->query($querystatement);
if(!$queryresult) $error = new appError(500,"Cannot retrieve Table Information");
$numfields = $db->numFields($queryresult);
for ($i=0;$i<$numfields;$i++) $fieldlist[]=$db->fieldTable($queryresult,$i).".".$db->fieldName($queryresult,$i);
?>