Welcome Guest, Not a member yet? Register   Sign In
SQL error? Why?
#1

Why do I get this error? Looks like it's not escaping.
Quote:Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 2

SELECT item FROM breakup_program_menu INNER JOIN breakup_members ON breakup_program_menu.program = breakup_members.program AND breakup_members.id = ?

Filename: models/Breakup_model.php

Line Number: 19
PHP Code:
public function program_items()
 {
 
$sql $this->db->query("
 SELECT item FROM breakup_program_menu INNER JOIN breakup_members 
 ON breakup_program_menu.program = breakup_members.program AND breakup_members.id = ? "
);
 
$this->db->query($sql, array(5)); 
 return 
$query->result();
 } 
Reply


Messages In This Thread
SQL error? Why? - by behnampmdg3 - 02-09-2015, 07:27 PM
RE: SQL error? Why? - by behnampmdg3 - 02-09-2015, 08:26 PM
RE: SQL error? Why? - by Avenirer - 02-09-2015, 11:57 PM
RE: SQL error? Why? - by Rufnex - 02-10-2015, 12:20 AM
RE: SQL error? Why? - by Narf - 02-10-2015, 02:17 AM



Theme © iAndrew 2016 - Forum software by © MyBB