#Get DMS list $dms_query = "SELECT customer_id, name FROM customer_master WHERE physical <> 'Y' AND customer_master_master_id IS NOT NULL ORDER BY name"; if (!$dms_result = mysql_query ($dms_query)) showerror(); $sql = 'SELECT placement_id, dms_customer_id, placement_name FROM dms_placement WHERE active = "Y" ORDER BY dms_customer_id, placement_name'; if (!$pl_result = mysql_query($sql)) showerror(); ?>