IE problems - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21) +--- Thread: IE problems (/showthread.php?tid=23819) |
IE problems - El Forum - 10-22-2009 [eluser]djjonex[/eluser] I have several querys, one inside another like: $query = $this->db->get_where('courses_lessons', array('user_id' => $user_id, 'family_id' => $family_id, 'course_id' => $course_id)); $this->db->order_by("lesson_number", "asc"); if ($query->num_rows() > 0) { foreach ($query->result() as $row) { $lesson_id = $row->lesson_id; $title = $row->title; $number_of_lessons = $row->number_of_lessons; $query = $this->db->get_where('courses_lessons_tasks', array('lesson_id' => $lesson_id)); if ($query->num_rows() > 0) { foreach ($query->result() as $row) { $lesson_number = $row->lesson_number; $query = $this->db->get_where('courses_lessons_specific_tasks', array('lesson_id' => $lesson_id, 'lesson_number' => $lesson_number)); $this->db->order_by("task_id", "asc"); if ($query->num_rows() > 0) { foreach ($query->result() as $row) { echo ... } } } } } } ok, so if you see, I have 3 SELECT query, $this->db->get_where('courses_lessons'... $this->db->order_by("lesson_number"... if ($query->num_rows() > 0)//if something exist, call the next query $query = $this->db->get_where('courses_lessons_tasks', array('lesson_id' => $lesson_id)); if ($query->num_rows() > 0)//if something exist, call next query $this->db->get_where('courses_lessons_specific_tasks'... $this->db->order_by("task_id"... In Firefox it works, but, For some reason the IE is confusing and says: A Database Error Occurred Error Number: 1054 Unknown column 'task_id' in 'order clause' SELECT * FROM (`courses_lessons_tasks`) WHERE `lesson_id` = '99' ORDER BY `task_id` asc it's mention the 2nd query when the order clause is in the 3rd query..... if somebody can help ...ill appreciate IE problems - El Forum - 10-22-2009 [eluser]djjonex[/eluser] I D K how ...but is working ... :S |