CI Noob having a problem...suprised?

[eluser]dantrag1989[/eluser]
[quote author="crumpet" date="1215723902"]Yeah i think you need to have quotes around your query. Also make sure your autoloading the database library in your autoload conf file.

Have you looked at the active record class? Its a little more code but its so easy to write queries its worth it.

//$sql = "SELECT * FROM library WHERE cat=Training";

would be

$this->db->where('cat', 'Training');
$query = $this->db->get('library');

if you don't want to SELECT * you can use
$this->db->select('name, color, etc');[/quote]

Yeah looks like it was combo of the curly brace and the quotes lol. Its the little things that trip you up...well they always trip me up lol. Thanks for all your help guys!

@Crumpet
I was looking at that earlier and was planning on moving to that once I found my mistake. I eventually want to change Training to a variable so I don't have to write a function for each category. Thanks for your help again!