IE problems

#1
[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

#2
[eluser]djjonex[/eluser]
I D K how ...but is working ... :S


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.