- if(!isset($discrim_queryalias)) {
- $discrim_queryalias = '';
- }
-
- if(!isset($discrim_queryand)) {
- $discrim_queryand = '';
- }
-
- $res_grp = db_query("
- SELECT *
- FROM trove_agg
- $discrim_queryalias
- WHERE trove_agg.trove_cat_id='$form_cat'
- $discrim_queryand
- ORDER BY trove_agg.trove_cat_id ASC, trove_agg.ranking ASC
- ", $TROVE_HARDQUERYLIMIT, 0, SYS_DB_TROVE);
+ $qpa = db_construct_qpa () ;
+ $qpa = db_construct_qpa ($qpa, 'SELECT * FROM trove_agg') ;
+ $qpa = db_join_qpa ($qpa, $qpa_alias) ;
+ $qpa = db_construct_qpa ($qpa, ' WHERE trove_agg.trove_cat_id=$1', array ($form_cat)) ;
+ $qpa = db_join_qpa ($qpa, $qpa_and) ;
+ $qpa = db_construct_qpa ($qpa, ' ORDER BY trove_agg.trove_cat_id ASC, trove_agg.ranking ASC') ;
+ $res_grp = db_query_qpa ($qpa, $TROVE_HARDQUERYLIMIT, 0, SYS_DB_TROVE);
+