Create list box from text field contents

Hi All,

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.


Hi Lyle,

You can use the [fphp]explode[/fphp] function to split the longtext field into an array, which you can then loop over to build your list box from.

Thanks so much!!!