Associative array

Hi,
I,m currently stuck with the following problem:
I would like to return from an MySql database an associative array that I want to format as a JSON object.
I’ve looked at the SC macro but nothing seems to suit my needs.
Could someone point me on the right direction to do that ?

Thanks

Sylvain

I think Mysql database does not have Arrays.
Here a forum. it can help you.
http://stackoverflow.com/questions/17371639/how-to-store-arrays-in-mysql
SAY: MySQL 5.7[SIZE=15px] now provides a JSON data type. This new datatype provides a convenient new way to store complex data: lists, dictionaries, etc.[/SIZE]