When a 'list' item, how to get beyond 'array' in Search Results page?

All my lookup tables, bar one, are 'menus.' When searching in the database, these items show up in the results with the entry for each record. So satisfying.

However, one of my lookup tables necessarily must be a 'list' - multiple values are possible. The menu works nicely in Insert / Update. However, the output for that menu item on the Results page is always 'array.'

May I learn, in my newbinesss, how to deal with this? Is there a way to see multiple results, for instance, or just one if there is only one in that particular record. Or perhaps, some sort of actual array in the results page, indicating what has been selected and what not?

Then of course, there is the question of how to use the outcome, in a binding on a page …

Probably too late tonight, so maybe let's do this Monday.

Thanks, David

when using a multiple select list, or multiple checkboxes, the selections will be transmitted as an array.

you can convert the array to a comma seperated listed using the implode function:

add this code at line 1:

<?php
if($_SERVER["REQUEST_METHOD"] == "POST")     {
	foreach($_POST as $key => $val) {
		if(is_array($_POST[$key])) $_POST[$key] = implode(", ", $_POST[$key]);
	}
}
?>

then you can write the comma separated list to the page using:

<?php echo((isset($_POST["ElementName"]))?$_POST["ElementName"]:"") ?>

where ElementName is the name of the select list.

Jason, thanks so much.

Since, on reflection, it seems we are better off with multiple checkboxes, this most directly addresses the question.

I am grateful, thanks.