List Box Multiple Select Problem

Waikula

I am trying to create a drop down list that permits a person to select multiple items from the list and have the results posted on a results page. I am using Dreamerweaver MX, PHP and a MYSQL database. I was able to select multiple items but only the last selected item would be displayed. I tried to modify the list box code and now it returns nothing. Any help would be appreciated.

Search page code is:

<p>Drop Down Menu</p>
<form action="multiplemenuresults.php" method="post" name="menuform" id="menuform">
<select name="selectstate[]" size="4" multiple id="selectstate">
<option value="%">All States</option>
<option value="California">California</option>
<option value="Georgia">Georgia</option>
<option value="New York">New York</option>
<option value="Washington">Washington</option>
</select>
<input name="menusubmit" type="submit" id="menusubmit" value="Submit">
</form>

Results page code is:

<?php
$statename_rsmenuresults = "%";
if (isset($HTTP_POST_VARS['selectstate'])) {
$statename_rsmenuresults = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['selectstate'] : addslashes($HTTP_POST_VARS['selectstate']);
}
mysql_select_db($database_statesearchconn, $statesearchconn);
$query_rsmenuresults = sprintf("SELECT city, state, company FROM jobs WHERE state LIKE '%s'", $statename_rsmenuresults);
$rsmenuresults = mysql_query($query_rsmenuresults, $statesearchconn) or die(mysql_error());
$row_rsmenuresults = mysql_fetch_assoc($rsmenuresults);
$totalRows_rsmenuresults = mysql_num_rows($rsmenuresults);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<p>Menu Results</p>
<ul>
<?php do { ?>
<li><?php echo $row_rsmenuresults['city']; ?>, <?php echo $row_rsmenuresults['state']; ?>, <?php echo $row_rsmenuresults['company']; ?> </li>
<?php } while ($row_rsmenuresults = mysql_fetch_assoc($rsmenuresults)); ?>
</ul>
</body>
</html>
<?php
mysql_free_result($rsmenuresults);
?>

tbach2

$query_rsmenuresults = sprintf("SELECT city, state, company FROM jobs WHERE state LIKE '%s'", $statename_rsmenuresults);

You forgot that $statename_rsmenuresults is an array. You'll have to build you query differently.

If for example, I select Georgia and New York, what should the query look like? I would try something like

SELECT city,state,company FROM jobs WHERE state IN('Georgia','New York') ORDER BY state

You could

$query_rsmenuresults = sprintf("SELECT city, `state`, company " . 
                              "FROM jobs " . 
                              "WHERE `state`IN('%s')",
                               implode("','",$statename_rsmenuresults)
);

Waikula

Thanks for the suggestion. I inserted the code and now I am getting an error message. The message is:

Parse error: parse error in c:\phpdev\www\newtestsite\multiplemenuresults.php on line 8

I think I entered it correctly but here is the code again:

<?php require_once('../Connections/statesearchconn.php'); ?>
<?php
$statename_rsmenuresults = "%";
if (isset($HTTP_POST_VARS['selectstate'])) {
$statename_rsmenuresults = (get_magic_quotes_gpc()) ? $HTTP_POST_VARS['selectstate'] : addslashes($HTTP_POST_VARS['selectstate']);
}
mysql_select_db($database_statesearchconn, $statesearchconn);
$query_rsmenuresults = sprintf("SELECT city, state, company" "FROM jobs" "WHERE state IN('%s')", implode ("','",$statename_rsmenuresults);
$rsmenuresults = mysql_query($query_rsmenuresults, $statesearchconn);
$row_rsmenuresults = mysql_fetch_assoc($rsmenuresults);
$totalRows_rsmenuresults = mysql_num_rows($rsmenuresults);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

Any further help would be greatly appreciated.

tbach2

I don't see any concatenation operators between the strings

help_needed

Hi,

I'd like to ask a follow up question with something related to the topic.

I have a drop down menu where multiple options can be selected or no options can be selected.

IE.

Select State.
Visitor Can Not select anything.
Visitor Can select ONE option.
Visitor can select AS MANY as he wishes.

How would I do a search with the input from the MULTIPLE SELECT FORM?

I can handle everything before the following line.

$query = "SELECT * FROM table WHERE ... ORDER BY id";

I can handle everything after the following line.

Now, what i need help with is the "WHERE ... " part.

I can do a standard one with just 1 value (WHERE state = '$state')

But, in this form, there will either be NO STATES, ONE STATE OR MANY STATES.

Can someone please help me?

Thanks,

tbach2

the answer is right above... use the values passed by your select statement in the IN( 'one_value_here','another_value_here') part of the query.

to figure out how the example above works, look up sprintf() at php.net and then look up in() at mysql.com.