Notice: Undefined variable: cid in C:\Data\web\backup-si\simm\serv\medcons.php on line 10

Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "order" LINE 4: where pr_cons_id= order by prit_clt_code ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select prit_icd10_code,prit_clt_code,prit_clt_copayment_percent,drg_name,prit_phf_code,prit_con_concentration,prit_dose,prit_quantity from prescription_items inner join prescriptions on pr_id=prit_pr_id left join drugs on (prit_drg_code=drg_code and drg_valid_to is null) where pr_cons_id= order by prit_clt_code
Warning: pg_num_fields(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 78

Notice: Undefined variable: arr in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 102

Warning: array_diff_key() [function.array-diff-key]: Argument #1 is not an array in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 102