[Resolved] [Resolved] multiple select

triponline

So I am asking too much.

How do I select multiple options on a form in aaa.php that will fit my sql statement on bbb.php.

Every time I attempt to do this I only get on bbb.php is the last selection from the several selections I made on aaa.php.

triponline.com/bta/aaa.php

Scroll down and select numerous items and press select.

triponlline.com/bta/bbb.php will only show your las selection.

Thanks for you help and Happy Holidays!

LordShryku

Change the select name from mlbl to mlbl[] to make it an array. Also make sure those options actually have values.

triponline

Just as I read your post I was thinking "array." These are things that have somewhat baffled. I understand them conceptually but putting them to work has been a task.

I placed the [] as suggested. Viola!! bbb.php now says "Array." Now we are getting somewhere.

How do I get it to do something useful. That is my next adventure. Glossing among my PHP books I encounter "array_values()." Is this what I use to view the values of the array? Any tips on how to use it?

LordShryku

You can loop through them. What do you want to do with them? For starters, let's echo them to the screen. Here's two seperate ways you can loop through them, though there are many more ways.

//example 1. foreach loop
foreach($_POST['mlbl'] as $blah) {
   echo $blah."<br />";
}

//example 2. for loop
for($i=0;$i<count($_POST['mlbl']);$i++) {
   echo $_POST['mlbl'][$i]."<br />";
}

triponline

Gave ex.1 a shot

Warning: Invalid argument supplied for foreach() in /home/tripon/public_html/bta/bbb.php on line 3

Invalid argument? My wife gives me these all the time but I do not think they apply here.

Is there something in the select statment causing this? This select statement is being populated with data from my database.

Gave ex.2 a shot

I get a blank sheet.

LordShryku

Right....just noticed you're using a get method in your form. Replace everything I said was $POST with $GET

triponline

Actually, I changed aaa.php to "post." Post is what I have always used because someone said it was better. I don't know. I only used get this time to affirm something was in fact going out.

Changing to "post" worked very well.

My actual task now is to get this data in some form that I can use in a "sql" statement to select data to create mailing labels.

SELECT AgencyName , Manager , Address1 , Address2 , Address3 , City , RegionISO , Postal
FROM tad1
WHERE 1 AND Postal
LIKE '80212-7068' OR Postal
LIKE '80215-3764' OR Postal
LIKE '22031-2400' OR Postal
LIKE '53217-1634' OR Postal
LIKE '8001' OR Postal
LIKE '80111-1227' OR Postal
LIKE '80111-2206' OR Postal
LIKE '80202' OR Postal
LIKE '90731-3105' OR Postal
LIKE '95054-3013' LIMIT 0 , 30

Somehow I need to get that array into some sort of loop that inserts those "LIKE '80212-7068' OR Postal
LIKE '80215 . . . into some sort of concatenation routine. I think I can turn this into some sort of variable to place in my sql statement. Am I headed the right direction?

LordShryku

Well, kinda almost in the right direction. LIKE is the wrong operater for this. You want =. And since you want it with multiple, you should use IN. Confused? Good 🙂

First, you want to build you list with what was chosen. You're going to want it comma delimeted, and with single quotes for the SQL. or this, we'll use [man]implode[/man].

Let's assume they chose
80212-7068
80215-3764
22031-2400

$areas = implode("','",$_POST['mlbl']);

This creates a string that looks like this:

80212-7068','80215-3764','22031-2400

Now let's put it together with the SQL statement....

$sql = "SELECT AgencyName, 
               Manager, 
               Address1, 
               Address2, 
               Address3, 
               City,
               RegionISO,
               Postal
          FROM tad1
         WHERE Postal IN ('".$areas."')"; 
$res = mysql_query($sql);

Using IN is the same as doing OR over and over.

triponline

Just so you know, I do appreciate your help! I am learning. . . I think.

triponline

$sql = "SELECT AgencyName, Manager, Address1, Address2, Address3, City, RegionISO, Postal FROM $table_name ORDER BY Postal";

$result = @($sql, $connection) or die ("Could not sql!");

while ($row = mysql_fetch_array($result)) {

$AgencyName = $row['AgencyName'];
$Manager = $row['Manager'];
$Address1 = $row['Address1'];
$Address2 = $row['Address2'];
$Address3 = $row['Address3'];
$City = $row['City'];
$RegionISO = $row['RegionISO'];
$Postal = $row['Postal'];

$option_block .= "<option value=\"$Postal\">$Postal, $RegionISO, $City</option>";

}

$display_block = "<select multiple name=\"mlbl[]\" >$option_block<\select>";

?>
<html>
<head>
<title>Pick It!</title>
</head>
<body>
<FORM METHOD ="post" ACTION ="bbb.php">
<? echo "$display_block"; ?><p>
<input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
</body>
</html>

LordShryku

probably because your closing tag for your select is <\select>, when it should be </select>