Dear all

I have use DW making a PHP site and has set a multiple selection
field..But I don't know how to write the SQL statement to database like

<select name="support[]" size="3" multiple="multiple" id="support">
<option value="1">Apple</option>
<option value="2">Orange</option>
<option value="3">Banana</option>
<option value="4">Watermelon</option>
</select>

If I choose 1 & 4, my database table will capture to array..I want the
DB can be caapture the 1,4, please teach me how to do this.(I know
array is a vars but i don't know how to write the statement)

BTW..If I would like recall this field to display. how to do it

Many thanks again

Ace

Ace wrote:
> Dear all
>
> I have use DW making a PHP site and has set a multiple selection
> field..But I don't know how to write the SQL statement to database like
>
> <select name="support[]" size="3" multiple="multiple" id="support">
> <option value="1">Apple</option>
> <option value="2">Orange</option>
> <option value="3">Banana</option>
> <option value="4">Watermelon</option>
> </select>
>
> If I choose 1 & 4, my database table will capture to array..I want the
> DB can be caapture the 1,4, please teach me how to do this.(I know
> array is a vars but i don't know how to write the statement)

Much depends on how you want to store the data

One line, comma between entries:
$theline=implode(',',$_REQUEST['support']);

Do something for each entry:
for($i=0;$i<count($_REQUEST['support']);$i++) {
$currentvalue=$_REQUEST['support'][$i];
/* do what you want with the $currentvalue */
}


> BTW..If I would like recall this field to display. how to do it

The above for loop.

--

//Aho