I need 2 values

where only 1 is recognized.

[grandpa]

I have a form. It contains 3 elements.

1: A text input
2: A Select statement with multiple options
3: A Select statement with multiple options

<form action="mycart" method="POST" name="Add1">
<input type="hidden" name="AddItem" value="me¦VARpack">
<input type="text" size="1" name="VARquantity" value="1">

<select name="VARpack" size="1">
<option value="VARname¦¦VARquantity¦¦blah2¦¦¦¦">Item</option>
</select>

<select name="VARname" size="1">
<option value="blah1 blah2">blah1</option>
</select>

I *need* to be able to return 2 items with VARname. Not 2 different selections, but 2 related items with any single selection (ie.; blah1 blah2). Am I up a creek?

grandpa

[txbakers]

try a union query

[grandpa]

According to this:

Union
Combines the results of two or more queries into a single
results set consisting of all the rows belonging to all
queries in the union.

I can get my data into a single table or use a JOIN or a UNION. I'm still stuck with the problem of passing multiple variables with the select NAME. If I assign more that a single value to the NAME, I need to parse the values out again.

I'm probably looking right at my solution, but beginning to feel dense after staring at this all day... gonna call it a night.