Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter2.11 sql variable type problems
#1

[eluser]smartweb[/eluser]
My code is no problem in version 2.1. But converted to Version 2.11, a serious error.


$this->db->update('articles',$save,'id ='.$id);





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 '`=6`' at line 1
UPDATE `cms_articles` SET `title` = 'ABCDE' WHERE `id` `=6`
Filename: D:\xampp\htdocs\www\6083\system\database\DB_driver.php
Line Number: 330


Messages In This Thread
CodeIgniter2.11 sql variable type problems - by El Forum - 06-15-2012, 02:19 AM
CodeIgniter2.11 sql variable type problems - by El Forum - 06-15-2012, 02:36 AM
CodeIgniter2.11 sql variable type problems - by El Forum - 06-15-2012, 04:02 AM
CodeIgniter2.11 sql variable type problems - by El Forum - 06-15-2012, 04:02 AM
CodeIgniter2.11 sql variable type problems - by El Forum - 06-15-2012, 06:32 AM
CodeIgniter2.11 sql variable type problems - by El Forum - 06-15-2012, 07:31 AM
CodeIgniter2.11 sql variable type problems - by El Forum - 06-15-2012, 05:35 PM



Theme © iAndrew 2016 - Forum software by © MyBB