changed query from tc_companionship to tc_companion to fix the ht interview scheduling
authorOwen Leonard <owen@balawis.leonard.fam>
Fri, 1 Oct 2010 20:07:32 +0000 (14:07 -0600)
committerOwen Leonard <owen@balawis.leonard.fam>
Fri, 1 Oct 2010 20:07:32 +0000 (14:07 -0600)
inc/class.tc.inc.php

index e2db75056776101e03c655f70bed7c4d174bbed4..a5e3138315ffe8938fe390b86d3a5a0180f3fff8 100644 (file)
@@ -1757,7 +1757,7 @@ class tc
                                $hti_pri = $entry['pri'];
                                //print "hti_notes: $hti_notes indiv_name: $indiv_name <Br>";
                                // Perform database save actions here
-                               $this->db->query("SELECT * FROM tc_companionship WHERE individual=$individual and valid=1",__LINE__,__FILE__);
+                               $this->db->query("SELECT * FROM tc_companion WHERE individual=$individual and valid=1",__LINE__,__FILE__);
                                if ($this->db->next_record()) {
                                        $scheduling_priority = $this->db->f('scheduling_priority');
                                        //$this->logToFile("int_sched", "UPDATE tc_scheduling_priority SET priority='$hti_pri', notes=\"$hti_notes\" WHERE scheduling_priority='$scheduling_priority'");