multiple selections search

Anon

I have a list box called 'location' allowing multiple selections in a form. When I search I get a URL: "./result.php?location=a&location=b&"

I want to display results WHERE location='a' OR location ='b' OR etc.

$HTTP_GET_VARS["location"] returns the last value only. How do I get an array of all the values?

Anon

try this..

<?php
$locations=array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z");

// set the default to a
$letter_num = 0;

// 26 different locations?
for($locationcount=0; $locationcount<26; $locationcount++){
$data=$HTTP_GET_VARS['$locations[$letter_num]'];
if($data){
echo "$locations[$letter_num]";
}
// keep the counting going till it gets to 26 🙂
$letter_num++;
}
?>

its a bit sloppy but it should work 🙂

Anon

slight adjustment to that code..

<?php
$locations=array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z");

// set the default to a
$letter_num = 0;

// 26 different locations?
for($locationcount=0; $locationcount<26; $locationcount++){
$data=$HTTP_GET_VARS['location'];
if($data == $locations[$letter_num]){
echo "$locations[$letter_num]";
}
// keep the counting going till it gets to 26 🙂
$letter_num++;
}
?>

Anon

The letters a, b, c, etc. are locations in a list and are taken from a database. Sorry about the misunderstanding.

How do I get the selected values from the list into the array?

Anon

presuming your using MySQL..

<?php
$query= "SELECT locations FROM table_name";
$result= mysql_query($query);
$locations = mysql_fetch_array($result);

// set the default to a
$letter_num = 0;

something like that..

Anon

I think I haven't explained myself very well. I have a list called 'location' in a form. It lists different locations from a database.

e.g. there are 7 locations and I select 3 of them. The URL will then contain "?location=1&location=2&location=3&" where 1,2 and 3 are the selected locations.

How do I use these values to perform a search WHERE location=1 OR location=2 OR location=3.

I assume the best way to do this is to make an array of the selected items before submiting the form or somehow get an array from the URL variables.

bretticus

Okay, I'm going to speculate this works via POST as well as via GET...

I also assume you just want to get an array out of a multiple select form element.

To do so simply add '[]' to the end of your select element name. i.e.

in the form handler, $location will be an array on all the values you selected.

Bretticus