my $sql = "SELECT ResType, ResLevel, ResManage, Details, Length, S
+ource, Cost, FurtherDetails 
          FROM ResourceSettings, Resources
          WHERE ResourceSettings.ResID=Resources.ResID ";
$sql.=" and ($where_clause) " if ($where_clause);
$sql.="   ORDER BY ResType, ResLevel, ResManage, 
                Details, Length, Source, Cost, FurtherDetails";