check boxes and search

[slimjim]

I want to add to a form multible checkboxes

<input type="checkbox" name="pop">Coke<br>
<input type="checkbox" name="pop">7up<br>

Then insert each that was checked into database table called food under a colum called pop

and then using a search such as :

select * from food WHERE pop LIKE '$pop'

But not sure how to do the insert because I am thinking it will insert like this:
Coke7up and I think they have to be seperated in order for the search to work correctly

Can anyone show me how to do this ?

[Houdini]

You have the right idea but to grab what you want you need to make the checkboxs an associative array as so

<input type="checkbox" name="pop['coke']" value="coke" />Coke<br>
<input type="checkbox" name="pop['7up']" value="7up" />7up<br> 

Then just check for arrays to see if they are set if so do something and if not just carry on with the process.

[slimjim]

How is get inserted into the database ? Isnt it going to look as one word ?

[slimjim]

would I use implode, and would that seperate the 2 so it would not look like one word and if so how ?

[MarkR]

No, you would insert it as several rows into another table with a foreign key pointing at your original table row.

Mark

[slimjim]

that makes no since to me what you mentioned now...