[Resolved] multiple variables - formatted like this

[sgtpepper]

I am trying to get the results from a form into the following format:

('first choice', 'second choice')

Basically, these are the results of a textbox. I want to have my variable

Basically I want to do something like:

$select = ('first choice', 'second choice')

How can I do this?

[stolzyboy]

does this have anything to do with your selecttown thread, if so, stick with that one, i was trying to help you, but kinda hard when you don't reply back with results/more questions

[sgtpepper]

Sorry, yes...I have been having problems with this so I have thought of another approach.

What if I can get the results formatted like I mentioned above and have my query like

where town in ($selecttown)

What that work as well?

[edwardsbc]

Something like this?...

$firstchoice=$_RESULT['yourformvar1'];
$secondchoice=$_RESULT['yourformvar2'];

$sql="SELECT * FROM mytable WHERE town IN ('$firstchoice','$secondchoice')";