From 31e82f5b8db3d29685e4818f96390c51bf44ad14 Mon Sep 17 00:00:00 2001
From: markleeds <markleeds>
Date: Thu, 17 Jan 2008 15:03:13 +0000
Subject: [PATCH] Change to yet another dumb query.

---
 interface/forms/CAMOS/rx_print.php | 12 +++---------
 1 file changed, 3 insertions(+), 9 deletions(-)

diff --git a/interface/forms/CAMOS/rx_print.php b/interface/forms/CAMOS/rx_print.php
index 06b338aa8..118c10eea 100755
--- a/interface/forms/CAMOS/rx_print.php
+++ b/interface/forms/CAMOS/rx_print.php
@@ -290,20 +290,14 @@ else {//pick
 <h1>Select CAMOS Entries for printing</h1>
 <form method=POST name='pick_items'>
 <?
-//foreach ($_SESSION as $key => $val) {
-//echo "$key => $val <br/>\n";
-//}
 $query = sqlStatement("select x.id as id, x.category, x.subcategory, x.item from " . 
- "form_CAMOS  as x join forms as y on (date(x.date) like date(y.date)) " . 
+ "form_CAMOS  as x join forms as y on (x.id = y.form_id) " . 
  "where y.encounter = " .  $_SESSION['encounter'] . 
  " and x.pid = " . $_SESSION['pid'] .  " and x.activity = 1");
 $results = array();
 while ($result = mysql_fetch_array($query, MYSQL_ASSOC)) {
-  $results["<input type=checkbox name='ch_" . $result['id'] . "'>" .
-    $result['category'] . ':' . $result['subcategory'] . ':' . $result['item'] . "<br/>\n"]++;
-}
-foreach($results as $key => $val) {
-  echo $key;
+  echo "<input type=checkbox name='ch_" . $result['id'] . "'>" .
+    $result['category'] . ':' . $result['subcategory'] . ':' . $result['item'] . "<br/>\n";
 }
 ?>
 <input type=submit name=print value=print>
-- 
2.11.4.GIT