[eluser]smatakajr[/eluser]
Hey
I can run this
SELECT r.affiliates_id, r.amount_owed, r.currency, r.mp_id, s.status_title, s.status_desc FROM relationships r JOIN status s ON (s.status_id = r.status_id) JOIN affiliates a ON (a.affiliates_id = r.affiliates_id) WHERE r.mp_id=60 AND (a.name LIKE "%rick%" OR a.email_address LIKE "%rick%" OR a.state LIKE "%rick%" OR a.paypal LIKE "%rick%" OR a.zip LIKE "%rick%" OR a.phone LIKE "%rick%" OR a.clickbank_id LIKE "%rick%" OR a.pdc_id LIKE "%rick%")
and the query works on the command line.. but when i run it through CI
$db->query() i get
An Error Was Encountered
Error Number: 1096
No tables used
SELECT *
What can do to figure out why?
any help is appreciated
Thank You
Rick