DB Help: db->query works but not equivilent db->get

DB Help: db->query works but not equivilent db->get

El Forum
Unregistered

04-02-2009, 04:03 PM

[eluser]jedd[/eluser]
Eeek! Apart from de-pluralising all those table names .. I'd suggest that you employ the services of the [url="http://ellislab.com/codeigniter/user-guide/general/profiling.html"]CI Profiling Class[/url] - this will show you, very easily and painlessly, the exact SQL queries being run, so you can get a clear idea of the actual differences once the thing hits the database.

Gut feel is possibly some quote / apostrophe characters causing some confusion .. but don't quote me on that. Haha.

Messages In This Thread

DB Help: db->query works but not equivilent db->get - by El Forum - 04-02-2009, 02:04 PM

DB Help: db->query works but not equivilent db->get - by El Forum - 04-02-2009, 04:03 PM

DB Help: db->query works but not equivilent db->get - by El Forum - 04-02-2009, 08:41 PM

DB Help: db->query works but not equivilent db->get - by El Forum - 04-03-2009, 01:09 AM

DB Help: db->query works but not equivilent db->get - by El Forum - 04-03-2009, 06:14 AM

DB Help: db->query works but not equivilent db->get - by El Forum - 04-03-2009, 01:09 PM

DB Help: db->query works but not equivilent db->get - by El Forum - 04-03-2009, 04:59 PM