Database update problem - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21) +--- Thread: Database update problem (/showthread.php?tid=28224) |
Database update problem - El Forum - 03-05-2010 [eluser]JohnnyBravo[/eluser] Newby question. I have to make more database operation after each other (insert, update). Controller: Code: $this->store_model->takein_advanced(); Model: Code: function takein() The first query runs well, but the second fails, because it generates something like this: Code: UPDATE `products` SET `products_in_store` = 'products_in_store + 12', `firm_id` = '1', And this table doesn't have fields like product_status, netto, tax, etc... So, the question is, after I ran the first query, how can I 'delete' the following: Code: $this->firm_id, $this->store_id, etc... Thank you! Database update problem - El Forum - 03-05-2010 [eluser]danmontgomery[/eluser] http://php.net/manual/en/function.unset.php |