Error", "Access denied.");
stdhead("Administration");
$sort=$_GET["sort"];
echo 'sort: ' . $sort . '
';
$type=($_GET["type"]=="asc"?"asc":"desc");
echo 'type: ' . $type . '
';
switch($sort){
case 1:$orderby="ORDER BY id ".$type;break;
case 2:$orderby="ORDER BY IA ".$type;break;
case 3:$orderby="ORDER BY claim_no ".$type;break;
case 4:$orderby="ORDER BY date_received ".$type;break;
case 5:$orderby="ORDER BY IVCV ".$type;break;
default:$orderby = "ORDER BY status, date_received";break;
}
$type=($_GET[type]=="asc"?"desc":"asc");
$addparam = "";
$addparam.="type=$type";
$query = "SELECT * FROM claims WHERE status = 'pending' $orderby";
echo 'query: ' . $query . '
';
//$res = mysql_query("SELECT * FROM claims WHERE status = 'pending' ORDER BY status, date_received") or sqlerr();
$res = mysql_query($query) or sqlerr();
$num = mysql_num_rows($res);
?>