I'm getting "Call to undefined function where()"

So besides the where function issue, perhaps someone could please comment on how best to perform more complex where clauses that are beyond the basic where( "table.column_name", php_variable_name ).

Don't, just use query().

So by that are you saying that I should just put the whole SQL Select statement, Joins, Where, Ands, Ors, Having, Sort, etc. all in there together, and not break them out as CI appears to want to you? I'm good with that, its more conventional when compared to other embedded SQL mechanisms, such as BDE and ODBC, on PCs.  If that's not what you're meaning, then would you explain some more?

Thnaks!