Using Multiple Variable Values

Nigel10

I would be grateful for any help with this problem using PHP with a MySQL database....

I have a search form facility based on a drop-down list (of products). I want searchers to be able to select more than one product from the drop-down to be used as search criteria. I have set up the form to allow multiple selections.

The variable values get passed in the form, e.g.

AdvancedResults.php?Products=AC&Products=BA

but it is only the second value that is 'held' and can be used.

How can I pass multiple values for a single variable to enable results from the database to be generated on a 'this value AND that value'basis?????

Many thanks

delfa

I suppose u can´t add another variable

In those cases I the following

I put Products=BA_CX

and I use explode to split, like this:

$products = explode('_',$_GET['Products']) //this will put the products in a array

to get the first product:

echo $products[0];

the second:

echo $products[1];

and so on

is this useful?

leatherback

Hi,

It may have to do with the way you set up the dropdown name: instead of using name=Products in your dropdownlist declaration, add [] at the end: name=Products[]

Then it should be recognized as an array of selected values.

Sxooter

Use an array:

Then you can reference them as

$token[0] and $token[1]

Nigel10

Thank you very much for these suggestions - I will try again and hopefully resolve. If not I will come back with my latest attempt.