[eluser]sbarow[/eluser]
Hi,
I am experiencing some very strange behavior, I am using CI's database class to get information from a MySQL database, everything loads fine, but if I add a new table or column to any table CI tells me that the table or column does not exist.
To break it down, I have a table called Info with columns home, about, products, services, if I use
Code:
$this->db->select('home');
$this->db->get('Info');
then everything works fine but if I then go into phpMyAdmin and insert a new column say "test" and then use the about query replacing "home" with "test" it tells me the column does now exist.
The same happens if I create a new table, it returns with the error that the table does not exist. Can anyone explain this and advise a possible fix?
Pretty damn frustrating.