I am developing a database using php and mysql. I have a table called actions which has fields 'actiondate' and 'notes'. I want to produce a table which gathers and displays all of the actions for a date so am using group_concat(notes separator ' ') AS grpnotes which works fine until there is too much data and it exceeds the limit. I have used google to find out that I need to use something like 'SET SESSION group_concat_max_len = 1000000;' which is fine but (as I am new to this) I have no idea how to get it into my code.
I am sure it is very simple but if anybody can give me some guidance that would be great.