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
#2

Anyone?
Reply
#3

SELECT item FROM breakup_program_menu INNER JOIN breakup_members ON breakup_program_menu.program = breakup_members.program WHERE breakup_members.id = ?
Reply
#4

write
... where breakup_members.id = ?

Reply
#5

Just look at what you're calling ... you're not passing any parameters for that query's execution.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB