+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Query Binding doesnt work (/showthread.php?tid=20974)
Query Binding doesnt work - El Forum - 07-27-2009
[eluser]HooJee[/eluser]
Hi Guys
Everytime I try to do query binding the queries are never executed, be it insert,update or select. Does anyone know how I can fix this ?
Code:
$sql_update_login = "UPDATE admin_users SET ip_address=?, last_login=NOW() WHERE id=?";
$this->db->query($sql_update_login, array(2, $ip, $id));Query Binding doesnt work - El Forum - 07-27-2009
[eluser]kgill[/eluser]
You're trying to bind to 2 params but passing 3 variables in, drop the 2 from your array.