Pagination for complex query

Pagination for complex query

#10

11-13-2009, 11:54 AM

[eluser]BrainCatcher[/eluser]
I ran out of idea's, let it rest for a few hour's .

And voila, the solution was there! Even pretty simple.

Quote:$this->db->select('*, COUNT(*) as count');

Just let mysql put the result in a variable, then you can retrieve the value easier.

Grtz BrainCatcher

Messages In This Thread

Pagination for complex query - by El Forum - 09-11-2009, 02:09 AM

Pagination for complex query - by El Forum - 09-11-2009, 03:16 AM

Pagination for complex query - by El Forum - 09-11-2009, 04:06 AM

Pagination for complex query - by El Forum - 09-11-2009, 05:30 AM

Pagination for complex query - by El Forum - 09-11-2009, 05:32 AM

Pagination for complex query - by El Forum - 09-11-2009, 05:49 AM

Pagination for complex query - by El Forum - 09-11-2009, 02:59 PM

Pagination for complex query - by El Forum - 10-22-2009, 05:13 PM

Pagination for complex query - by El Forum - 11-13-2009, 08:23 AM

Pagination for complex query - by El Forum - 11-13-2009, 11:54 AM

Pagination for complex query - by El Forum - 11-13-2009, 01:47 PM

Pagination for complex query - by El Forum - 12-12-2009, 05:51 PM