Welcome Guest, Not a member yet? Register   Sign In
ActiveRecord not returning any results for particular table
#1

[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());
gives the result
Code:
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

Code:
print_r($this->db->get('repository_noteupdates')->result_array());
gives the result
Code:
Array
(
)

Have any of you guys seen anything like this before. It is really driving me crazy!

Thanks for reading.
#2

[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! Smile




Theme © iAndrew 2016 - Forum software by © MyBB