+- 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: $this->db->affected_rows() always returning 0 (/showthread.php?tid=12920)
$this->db->affected_rows() always returning 0 - El Forum - 11-04-2008
[eluser]Armchair Samurai[/eluser]
I'm not sure exactly if this is a CI problem, a MySQL problem or something completely different, but the affected_rows() function doesn't seem to be working properly for this query.
In one of the models, I have this function:
Code:
function edit($arr)
{
$sql = "INSERT INTO table (id_1, id_2, foo, bar, created)
VALUES (?, ?, ?, ?, ?)
ON DUPLICATE KEY
UPDATE foo = VALUES(foo), bar = VALUES(bar), modified = VALUES(created)";
$this->db->query($sql, $arr);
return $this->db->affected_rows() > 0 ? TRUE : FALSE;
}