[rush989]

Hi there,

I'm kinda stumped on how to do this. I have a list box where I can select multiple things by holding down control (example at: http://www.mypartz.com/example.html). I was wondering how I could get the selected items into a variable so I can put them into one field in my database. The values can be in the variable separated by spaces or commas. This is so I can use my friend's search script on the variable to display certain rows.

When I try it out by using
$query = "INSERT INTO reviews (keywords) VALUES ('$keywords')";
it only puts in the last value selected.

I'm a beginner in php so I don't really know much but as long as it's in a variable I will know what to do. Thanks everyone!

[mdhall]

Use this on your form....
<SELECT name="select_name[]">

Then in your script to insert, use this....
$abc=$_POST['select_name];
for ($i=0; $i<count($abc); $i++){
$field_name = $field_name." ".$abc[$i];
}
$query = "INSERT INTO table_name VALUES ('$field_name')";