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
print_r($this->db->get('repository_notes')->result_array());
gives the result
Array
(
[0] => Array
(
[note_id] => 1
[note_title] => This is my note
[note_content] => Lorem ipsum dolor sit amet, consectetur adipiscing elit. In laoreet lobortis lacus, ac iaculis risus tristique nec. Curabitur porta gravida est, non tincidunt nunc porta nec. Nunc diam metus, feugiat non lobortis
[note_userId] => 2302
[note_pageno] => 12
[note_deleted] => 0
[note_bookid] => 12
)
[1] => Array
(
[note_id] => 2
[note_title] => This is my note
[note_content] => Lorem ipsum dolor sit amet, consectetur adipiscing elit. In laoreet lobortis lacus, ac iaculis risus tristique nec. Curabitur porta gravida est, non tincidunt nunc porta nec. Nunc diam metus, feugiat non lobortis
[note_userId] => 2302
[note_pageno] => 12
[note_deleted] => 0
[note_bookid] => 12
)
etc...
etc...
However
print_r($this->db->get('repository_noteupdates')->result_array());
gives the result
Array
(
)
Have any of you guys seen anything like this before. It is really driving me crazy!
Thanks for reading.
