Tag Archives: group_concat issues in mysql

group_concat function not returning all values. one extra comma adding at the end of the data

solution is use the below code in your model $this->db->simple_query(‘SET SESSION group_concat_max_len=1000000’); refer the below link for more details http://mydoubts.in/blog/group_concat-function-not-returing-all-values-in-mysql-it-returns-some-values-with-one-comma-at-the-end/

group_concat function not returing all values in mysql–it returns some values with one comma at the end.

If you execute the below code and try to execute the query through phpmyadmin/php script. it will return only few records not all records. you can use the below files,db sructure to check the issues database table- create a table inside the db called ‘test’

# index.php

#connect.php

To get proper values… Read More »