+- 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: please correct my code (/showthread.php?tid=54864)
please correct my code - El Forum - 09-28-2012
[eluser]Fahad Alrahbi[/eluser]
hello again
can anyone correct my code
Model
Code:
function update_order($id,$old_order){
//Update The order
$query = $this->db->query("SELECT * FROM cat WHERE `cat_order`='$old_order' ");
$row = $query->row();
$this->db->query("UPDATE cat SET cat_order='".$row->cat_order."' WHERE id='".$id."' ");
$this->db->query("UPDATE cat SET cat_order='$old_order' WHERE id ='".$row->id."' ");
}please correct my code - El Forum - 09-29-2012
[eluser]rose_anne[/eluser]
what error message did you get.. maybe i could help you
you could also try to use the codeigniter update function http://ellislab.com/codeigniter/user-guide/database/active_record.html#update