Pagination with sorting

Pagination with sorting

El Forum
Guest

#28

02-27-2009, 08:00 PM

[eluser]spyro[/eluser]
[quote author="dmorin" date="1235807534"]When you run the version with the join, and you only get one row, is that row correct? ie it is a valid record and has the correct number of reviews? Or is the count of reviews exaggerated?

It shouldn't be necessary, but also try adding $this->db->group_by('a.id'); to the query.[/quote]

You were right on both accounts. The number of reviews were exaggerated and adding the group by fixed it.

Messages In This Thread

Pagination with sorting - by El Forum - 02-27-2009, 11:21 AM

Pagination with sorting - by El Forum - 02-27-2009, 11:39 AM

Pagination with sorting - by El Forum - 02-27-2009, 12:26 PM

Pagination with sorting - by El Forum - 02-27-2009, 12:48 PM

Pagination with sorting - by El Forum - 02-27-2009, 01:39 PM

Pagination with sorting - by El Forum - 02-27-2009, 01:54 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:10 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:19 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:36 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:47 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:52 PM

Pagination with sorting - by El Forum - 02-27-2009, 02:58 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:08 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:16 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:27 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:28 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:34 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:40 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:42 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:52 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:56 PM

Pagination with sorting - by El Forum - 02-27-2009, 03:58 PM

Pagination with sorting - by El Forum - 02-27-2009, 04:09 PM

Pagination with sorting - by El Forum - 02-27-2009, 04:43 PM

Pagination with sorting - by El Forum - 02-27-2009, 07:10 PM

Pagination with sorting - by El Forum - 02-27-2009, 07:29 PM

Pagination with sorting - by El Forum - 02-27-2009, 07:52 PM

Pagination with sorting - by El Forum - 02-27-2009, 08:00 PM

Pagination with sorting - by El Forum - 02-27-2009, 10:20 PM

Pagination with sorting - by El Forum - 02-28-2009, 09:38 AM