Mysql Custom Select

Mysql Custom Select

nahid.tct
Newbie
Posts: 3
Threads: 1
Joined: Jan 2015
Reputation: 0

01-03-2015, 10:34 PM

I use below query:

$query = $this->db->query('select * from class_routine where semester='$semester' and day='$day' and time_schedule='$time_schedule' and (batch='$batch_no' or section='$section' or teacher='$teacher' or room='$room');');

And I get this error:

Parse error: syntax error, unexpected '$semester' (T_VARIABLE) in C:\xampp\htdocs\crm\application\models\m_class_routine.php on line 9

Messages In This Thread

Mysql Custom Select - by nahid.tct - 01-03-2015, 03:59 AM

RE: Mysql Custom Select - by bclinton - 01-03-2015, 09:07 AM

RE: Mysql Custom Select - by nahid.tct - 01-03-2015, 10:34 PM

RE: Mysql Custom Select - by Jamie - 01-04-2015, 10:15 AM

RE: Mysql Custom Select - by nahid.tct - 01-04-2015, 11:37 AM

RE: Mysql Custom Select - by InsiteFX - 01-05-2015, 04:45 AM

RE: Mysql Custom Select - by bclinton - 01-05-2015, 09:32 AM