Topic: strange GROUP_CONCAT problem

[mabog]

When adding GROUP_CONCAT to the query, row count is:
Showing rows 0 - 0 (1 total, Query took 0.0224 sec)
Without GROUP_CONCAT:
Showing rows 0 - 4 (5 total, Query took 0.0215 sec)

So in the first case mysql_num_rows() doesn't work anymore EVEN query result (via PHPMySQL) is OK!

Why row count is zero??

[mabog]

It's PHPMyAdmin, not PHPMySQL 

Still need help with this "showing rows 0-0" 

[fenway]

Really? You asked mysql to group everything into a single record -- and it did -- so why are you blaming a function?

[mabog]

Really? You asked mysql to group everything into a single record -- and it did -- so why are you blaming a function?

It's not a single record, it's 5 rows, in both cases. But with GROUP_CONCAT row count is zero even rows are visible!
Anyway I solved this with second query and with simple php comparison.

[fenway]

There is no possible way that with and without group-concat you get the same number of rows.

[mabog]

There is no possible way that with and without group-concat you get the same number of rows.

OK. Can't remember anymore was there 3 or 4 or 5 rows but at least there was few. But still 'showing rows 0-0' ...

[fenway]

But still "1 total".

[mabog]

But still "1 total".

Which is incorrect because there was more than 1 row.

But I tested that query again, with / without group_concat:
Without: Showing rows 0 - 7 (8 total, Query took 0.0218 sec), 8 rows visible
With: Showing rows 0 - 0 (1 total, Query took 0.0220 sec), 8 rows visible

??

[fenway]

Show both result sets.