[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
