[eluser]jedd[/eluser]
[quote author="Kyle Wiebers" date="1256783589"]
Currently nothing is returned when I try to access it in a Controller. When I try to run the same query in a DBMS it returns the expected value.
[/quote]
When you say
same query do you mean the absolutely identical same query - and you know it's identical because you have run the profiler, or used the ->db->last_query thing and ascertained that you're using exactly the same code ... or do you mean that you
believe it's the same query, despite the fact that it obviously isn't (otherwise it would work, right?)
So .. what did the profiler reveal about what your query got translated to before being zapped off to the DB?
Without wishing to second guess your own debugging attempts, I'd suggest this bit:
Code:
... TITLE = '.$name.'LIMIT 1')
... is asking for trouble. A space before LIMIT would probably make it happier.
EDIT: you should also do some num_row count checks before trying to return any data.