COUNT(*) returning 0 ?

COUNT(*) returning 0 ?

El Forum
Unregistered

#15

10-20-2009, 09:22 AM

[eluser]sl3dg3hamm3r[/eluser]
Or you can try to deny backticks. From the user guide:

Quote:$this->db->where() accepts an optional third parameter. If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks.

Code:
$this->db->where('MATCH (field) AGAINST ("value")', NULL, FALSE);

But it is really bad practice to have blanks in your field-names. I would rename that, too.

Messages In This Thread

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 06:58 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:11 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:23 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:25 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:40 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:43 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 07:50 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 08:10 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 08:32 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 08:38 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 08:54 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 08:57 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:06 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:12 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:22 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:31 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:33 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 09:40 AM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 10:08 PM

COUNT(*) returning 0 ? - by El Forum - 10-20-2009, 10:16 PM