Select Box

raouleduke

How do I allow users to select multiple items in this it doesn't seem to work.

$query1_result = mysql_query ("SELECT DISTINCT ZIP FROM table");
$num_results = mysql_num_rows($query1_result );
$catagories = array();
//use the for loop to populate the array with the unitnos from the query
for ($i=0; $i<$num_results; $i++)
{
  $ZIP_row=mysql_fetch_object($query1_result );
  $catagories[]=$ZIP_row->ZIP;
}

//start the dropdown box
echo "<select name=\"ZIP\" value=\"$ZIP\" size=\"50\" multiple>"; 
//detect if this script has been submited yet
if (!isset ($ZIP)) 
{
  $selected_ZIP = "";
}
else
{
  $selected_ZIP = $ZIP;
}
if ($selected_ZIP == "")
{
  echo "<option value=\"\" SELECTED>SELECT ZIP</option>";
}
else
{
  echo "<option value=\"\" >SELECT ZIP</option>";
}
//populate the option and provZIPe a SELECTED option for each item in the array

foreach ($catagories as $ZIP)
{    

  if ($selected_ZIP == $ZIP) 
  {
    echo "<option value=\"$ZIP\" SELECTED >$ZIP</option>";
  }
  else
  {
    echo "<option value=\"$ZIP\" >$ZIP</option>";
  }
}
echo "</select><br>";
echo "<input type=submit value=Submit name=Submit>\n";
echo "</form>\n";

raouleduke

It does work but is there a way for the user not to have to hold the control key to select records.

Thanks in advance.

Kudose

No. If I am wrong, please correct me.

raouleduke

thanks for replying, I am pas that they will just have to do it. Here is another question for you. How do I have the field for the select box change based on the selected Field, the field is defined by $sort.

Here is the script.

$query1_result = mysql_query ("SELECT DISTINCT $sort FROM LUTHERSELLANDRECOMMEND");
$num_results = mysql_num_rows($query1_result );
$catagories = array();
//use the for loop to populate the array with the unitnos from the query
for ($i=0; $i<$num_results; $i++)
{
  '$sort'_row=mysql_fetch_object($query1_result );
  $catagories[]='$sort'_row->'$sort';
}

//start the dropdown box
echo "<select name=\"'$sort'\" value=\"'$sort'\" size=\"50\" multiple>"; 
//detect if this script has been submited yet
if (!isset ($'$sort')) 
{
  $selected_'$sort' = "";
}
else
{
  $selected_'$sort' = $'$sort';
}
if ($selected_'$sort' == "")
{
  echo "<option value=\"\" SELECTED>SELECT '$sort'</option>";
}
else
{
  echo "<option value=\"\" >SELECT '$sort'</option>";
}
//populate the option and prov'$sort'e a SELECTED option for each item in the array

foreach ($catagories as $'$sort')
{    

  if ($selected_'$sort' == $'$sort') 
  {
    echo "<option value=\"$'$sort'\" SELECTED >$'$sort'</option>";
  }
  else
  {
    echo "<option value=\"$'$sort'\" >$'$sort'</option>";
  }
}
echo "</select><br>";
echo "<input type=submit value=Submit name=Submit>\n";
echo "</form>\n";

Kudose

Can you explain that a little better. Sorry, it is late, and I am tired, so I am slow.

Also use the [PHP} tags, you had them right, but they need to be in CAPS and have the closing /

raouleduke

What I am doing is having the users select all the distinct records from a database that they want to sort by, there are 10 different fields that I am sorting by, basically what I am doing is creating a sql query based upon what the user selects, then I will have it set all the records pertaining to what they have selected, to active.