Hi, Here's my dilemma.
I know I can download all my entries via the CSV download feature; however I create reports using ARI Tables to pull field data from the MySQL database of my hosting server so I can have real time updates appear for reports online using ARI Tables Module. Student Volunteer Form
I can pull all the single fields in single column; however the custom fields I created in my form treated them as one field of data
[color=#ff0000]eg:
newfields
17::10;34::;11::;19::;20::;21::;22::;23::Not_Applicable;24::;33::;25::yes;26::;27::;28::Football;29::Kyle Simmons;30::;31::;32::;16::;[/color]
Is this intentionally done when an entry is made to have all the data sit in one field called newfields?
Is there an SQL command/function that I can use to be able to split the data into new separate columns in my reports.
Here's my current SQL statements required in the ARI Table Module:
[color=#0000bb]SELECT
`name`,
`email`,
`bookingdate` as "Record Date",
`grade`,
`comment`,
newfields as "Custom Fields"
FROM `jml_matukio_bookings`
ORDER BY name ASC[/color]
Thanks