[Solved] GROUP CONCAT not work correct

Maybe '  >  ' would have a better chance of working.

If not:
If you take the query generated by query builder (output the result of get_compiled_select() or use the profiler or a debugger) and execute it against your database (i.e. in MySQL Workbench), do you get the expected results? Have you tried using a separator which doesn't include any special characters?

Hi @mwhitney

I have found the cause of the issue is on my add category function.

When ever I create a category if it is a sub category in my category_path table

If category id is lets say 22 and parent id 19

Then  on table row should have two rows

22 19
22 22

For some reason on my model add function it's not inserting the path id correct now I know what to do

I add image of working category list now.

Attached Files

Thumbnail(s)
   

There's only one rule - please don't tell anyone to go and read the manual.  Sometimes the manual just SUCKS!