ActiveRecord not returning any results for particular table |
[eluser]Unknown[/eluser]
Hey Guys, Having a problem with returning results from one particular table in a database. I have two tables: a) repository_notes b) repository_noteupdates (this one is giving the problem) Here is an image showing there are some data in both tables using a simple select * query using Navicat. http://imgur.com/GA6bn However I only get results from repository_notes Code: print_r($this->db->get('repository_notes')->result_array()); Code: Array However Code: print_r($this->db->get('repository_noteupdates')->result_array()); Code: Array Have any of you guys seen anything like this before. It is really driving me crazy! Thanks for reading.
[eluser]Unknown[/eluser]
I have resolved the issue. I renamed the problem table so that update is not part of the name. Now it is working. FYI: You cannot use update in the name of a database table! |
Welcome Guest, Not a member yet? Register Sign In |