Automatic Selected Option + Select Menu

[obrienkev]

Hi all,

When the below menu is selected from it is processed by PHP code(PART II)

I want the selected option to then be displayed automatically.

However, the bottom option is automatically displayed.

How do I fix this?? Thanks.

	 <p>
	   <label for="name" class="personal">Fund Name</label>
		 <select name="fund_name" id="fund_name" onchange="change(this.options[selectedIndex].value);">
		  <?php

		if(isset($fund_name) && ($fund_name !="0"))
	  {
			echo $options_fund .= '<option value="'.$new_fund_ID.'" selected="selected">'.$new_fund_name.'</option>';
			//echo $options_fund;
	  }
	  else
		{
		?>
		<option value="0">Select Fund Name</option>
		<?php
		//echo '<option value="'.$option_list[0].'">'.$option_list[1].'</option>';
		echo $options_fund;
		}
		?>	 
	 </select><span class="tip"> 2/ Select Fund Name</span>
 </p>

PART II - CODE PROCESSES THE SELECT MENU

   // GET FUND NAME
	 $query_fund = "SELECT fund_ID, client_ID, fund_name ".
	 					     "FROM fund_name ".
								 "WHERE client_ID = '$client'";
	 echo '<p>Q: '.$query_fund.'</p>';
	 $result_fund = mssql_query($query_fund) or die('Select Fund Name Error');

 $options_fund = ''; // SET OPTION VAR

   while($row_fund = mssql_fetch_array($result_fund)) // LOOP RESULTS
   {
     $options_fund .= '<option value="'.$row_fund['fund_ID'].'">'.$row_fund['fund_name'].'</option>';
	   $new_fund_name = $row_fund['fund_name']; // SET SELECTED VALUE
		 $new_fund_ID = $row_fund['fund_ID']; // SET SELECTED VALUE
	 } // END WHILE

[bpat1434]

$fund_ID = (!isset($_POST['fund_name']) || empty($_POST['fund_name'])) ? '' : $_POST['fund_ID'];

while($row_fund = mssql_fetch_array($result_fund))
{
  $options_fund .= '<option value="'.$row_fund['fund_ID'].'"' . (($row_fund['fund_ID'] == $fund_ID) ? 'selected="selected"' : '' ) . '>'.$row_fund['fund_name'].'</option>';
  $new_fund_ID = $row_fund['fund_ID'];
}

Should work. You just have to check to see if the $_POST['fund_name'] is empty or holds a value, and then in the loop, compare it with each itteration of the while loop.

[obrienkev]

Added the above but does the same.

Here's the select menu itself...

	 <p>
	   <label for="name" class="personal">Fund Name</label>
		 <select name="fund_name" id="fund_name" onchange="change(this.options[selectedIndex].value);">
		  <?php

		if(isset($fund_name) && ($fund_name !="0"))
	  {
			echo $options_fund .= '<option value="'.$new_fund_ID.'" selected="selected">'.$new_fund_name.'</option>';
			//echo $options_fund;
	  }
	  else
		{
		?>
		<option value="0">Select Fund Name</option>
		<?php
		//echo '<option value="'.$option_list[0].'">'.$option_list[1].'</option>';
		echo $options_fund;
		}
		?>	 
	 </select><span class="tip"> 2/ Select Fund Name</span>
 </p>

[bpat1434]

this:

                echo $options_fund .= '<option value="'.$new_fund_ID.'" selected="selected">'.$new_fund_name.'</option>';
                //echo $options_fund; 

Should probably be this:

                //echo $options_fund .= '<option value="'.$new_fund_ID.'" selected="selected">'.$new_fund_name.'</option>';
                echo $options_fund; 

[obrienkev]

Hi, it now sets to the first select option.

any ideas why this might be? thanks.

// CHECK IF CLIENT SELECTED
if(isset($client) && $client !="0")
{
   // GET CLIENT NAME
	 $query_client = "SELECT client_name ".
	 					       "FROM client ".
									 "WHERE client_ID = '$client'";
	 $result_client = mssql_query($query_client) or die('Select Client Error');
	 $row_client = mssql_fetch_array($result_client);
	 $client_name = $row_client['client_name'];



   // GET FUND NAME
	 $query_fund = "SELECT fund_ID, client_ID, fund_name ".
	 					     "FROM fund_name ".
								 "WHERE client_ID = '$client'";
	 //echo '<p>Q: '.$query_fund.'</p>';
	 $result_fund = mssql_query($query_fund) or die('Select Fund Name Error');

 $options_fund = ''; // SET OPTION VAR

   while($row_fund = mssql_fetch_array($result_fund)) // LOOP RESULTS
   {
     $options_fund .= '<option value="'.$row_fund['fund_ID'].'">'.$row_fund['fund_name'].'</option>';
	   $new_fund_name = $row_fund['fund_name']; // SET SELECTED VALUE
		 $new_fund_ID = $row_fund['fund_ID']; // SET SELECTED VALUE
	 } // END WHILE

[bpat1434]

Okay, let's take a look at this entire thread:

   while($row_fund = mssql_fetch_array($result_fund)) // LOOP RESULTS
   {
     $options_fund .= '<option value="'.$row_fund['fund_ID'].'">'.$row_fund['fund_name'].'</option>';
       $new_fund_name = $row_fund['fund_name']; // SET SELECTED VALUE
         $new_fund_ID = $row_fund['fund_ID']; // SET SELECTED VALUE
     } // END WHILE 

That's the current code your working with (or at least the current code you posted), which is exacly like the first code you posted:

   while($row_fund = mssql_fetch_array($result_fund)) // LOOP RESULTS
   {
     $options_fund .= '<option value="'.$row_fund['fund_ID'].'">'.$row_fund['fund_name'].'</option>';
       $new_fund_name = $row_fund['fund_name']; // SET SELECTED VALUE
         $new_fund_ID = $row_fund['fund_ID']; // SET SELECTED VALUE
     } // END WHILE 

Now, the answer was given back in this part:

while($row_fund = mssql_fetch_array($result_fund))
{
  $options_fund .= '<option value="'.$row_fund['fund_ID'].'"' . (($row_fund['fund_ID'] == $_POST['fund_name']) ? 'selected="selected"' : '' ) . '>'.$row_fund['fund_name'].'</option>';
  $new_fund_ID = $row_fund['fund_ID'];
} 

So compare. What is it that I have, that you don't in your code? It's a short ternary operator. You need to add this:

' . (($row_fund['fund_ID'] == $_POST['fund_name']) ? 'selected="selected"' : '' ) . '

directly after the value="whatever" in your code (just like my code) and you'll be all set.

[obrienkev]

this works guys. thanks for the help.

// CHECK IF CLIENT SELECTED
if(isset($client) && $client !="0")
{
   // GET CLIENT NAME
     $query_client = "SELECT client_name ".
                                "FROM client ".
                                     "WHERE client_ID = '$client'";
     $result_client = mssql_query($query_client) or die('Select Client Error');
     $row_client = mssql_fetch_array($result_client);
     $client_name = $row_client['client_name'];



   // GET FUND NAME
     $query_fund = "SELECT fund_ID, client_ID, fund_name ".
                              "FROM fund_name ".
                                 "WHERE client_ID = '$client'";
     //echo '<p>Q: '.$query_fund.'</p>';
     $result_fund = mssql_query($query_fund) or die('Select Fund Name Error');

 $options_fund = ''; // SET OPTION VAR

   while($row_fund = mssql_fetch_array($result_fund)) // LOOP RESULTS
   {
     //$options_fund .= '<option value="'.$row_fund['fund_ID'].'">'.$row_fund['fund_name'].'</option>';

     $options_fund .= '<option value="'.$row_fund['fund_ID'].':'.$row_fund['fund_name'].'">'.$row_fund['fund_name'].'</option>';

 } // END WHILE


}// END CLIENT CHECK



$fund_name = $_POST['fund_name'];
//print_r($fund_name);

// SPLIT FUND NAME VAR
$fund_name_explode = explode(":", $fund_name);
$new_fund_ID = $fund_name_explode['0'];
$new_fund_name = $fund_name_explode['1'];



// CHECK IF FUND NAME SELECTED
if(isset($fund_name) && $fund_name !="0")
{

 // SET SELECTED OPTION VAR
 $options_fund .= '<option value="'.$new_fund_ID.':'.$new_fund_name.'" selected="selected">'.$new_fund_name.'</option>';

Select Menus:

     <?php

   // SELECT CLIENT
     $query = "SELECT client_ID, client_name ".
                         "FROM client";
   $result = mssql_query($query) or die('Select Error');

     if(isset($client) && ($client !="0"))
     {
            $option .= '<option value="'.$client.'" selected="selected">'.$client_name.'</option>';
            while($row = mssql_fetch_array($result))
        {
                // SET OPTION
               $option .= '<option value="'.$row['client_ID'].'">'.$row['client_name'].'</option>';
            } // END WHILE
     }
     else
     {
        while($row = mssql_fetch_array($result))
        {
                // SET OPTION
               $option .= '<option value="'.$row['client_ID'].'">'.$row['client_name'].'</option>';
            } // END WHILE
     }// END IF ELSE

 ?>

 <p>
   <label for="client" class="lbl_group">Client</label>
     <select name="client" id="client" onchange="change(this.options[selectedIndex].value);">
      <option value="0">Select Client</option>
        <?php
        echo $option;
        ?>
     </select><span class="tip"> 1/ Select Client</span>
 </p>



 <p>
   <label for="name" class="personal">Fund Name</label>
     <select name="fund_name" id="fund_name" onchange="change(this.options[selectedIndex].value);">
      <?php

        if(isset($fund_name) && ($fund_name !="0"))
      {
            //echo $option_f = '<option value="'.$fund_name_explode[0].'" selected="selected">'.$fund_name_explode[1].'</option>';
            //echo $options_fund .= '<option value="'.$new_fund_ID.'" selected="selected">'.$new_fund_name.'</option>';
            echo $options_fund;
      }
      else
        {
        ?>
        <option value="0">Select Fund Name</option>
        <?php
        //echo '<option value="'.$option_list[0].'">'.$option_list[1].'</option>';
        echo $options_fund;
        }
        ?>     
     </select><span class="tip"> 2/ Select Fund Name</span>
 </p>

[bpat1434]

No problem. Don't forget to mark this thread resolved.