[eluser]stormbytes[/eluser]
[quote author="tonanbarbarian" date="1287901783"]tell us the exact query you expect it to produce
and then run the following command after the ->db->get() and see what the query is actually producing
Code:
echo $this->db->last_query();
[/quote]
I expect it to access the 'Revisions' table, retrieve the 'date' field, format the date field like I expressed, retrieve the revisions field, and return the data to the controller that called it.
Frankly I'm really stumped.
This query works just fine in mysql client locally -
In fact, it actually half-works in CI. It retrieves the data from the revision field but the date field is generating an error. I'm guessing it's got something to do with the single-quotes as I've executed similar functions in other queries without a problem.