lyleholc — 2013-07-23T03:19:15-04:00 — #1
I have a MYSQL table that has a longtext field with items separated by semicolons. I'd like to figure out a query and/or php code that when the user selects a record from a list, the longtext field will display as a scrolling item list adjacent to the main list. So the query/code will have to break out the items in the longtext field using the semicolon as a separator and then display those items in a list box adjacent to the highlighted record in the main list box.
Thanks in advance for any suggestions.
fretburner — 2013-07-23T08:18:43-04:00 — #2
You can use the explode function to split the longtext field into an array, which you can then loop over to build your list box from.
lyleholc — 2013-07-23T11:22:05-04:00 — #3
Thanks so much!!!