-1

this is my courses table :
student_id || course_id || group
12345 || 1 || 0
12346 || 2 || 0
12347 || 2 || 1 

//for example $course_id = 2 and $group = 0   
$query=$this->db->query("DELETE FROM courses WHERE group=".$group." AND course_id = ".$course_id);  
$query=$this->db->query("DELETE FROM courses WHERE course_id = ".$course_id);  
$query=$this->db->query("DELETE FROM courses WHERE group=".$group);
Your Common Sense
  • 156,878
  • 40
  • 214
  • 345
hassan rezay
  • 25
  • 6
  • 1
    add question with proper details as you have said in title third works but in comments you have said ahhh its not working ,so add proper question bcz wrong information can misguide other users. – Keval Aug 20 '15 at 10:12

1 Answers1

1

group is reserved keyword in mysql it is used in backtick

$query=$this->db->query("DELETE FROM courses WHERE `group`=".$group." AND course_id = ".$course_id);

Or using Active record you can write your query 

$this->db->where('`group`',$group);
$this->db->where('course_id',$course_id);
$this->db->delete('courses');
Saty
  • 22,443
  • 7
  • 33
  • 51