PHP - Dynamic Option Menu With Selected Not Working

If I have a variable and a hard coded select dropdown, what is the easiest way to compare the variable with the value and set that particular option's selected attributed to selected?

<?php  
                              if(mysqli_num_rows($result) )  
                          {  
                               while($row = mysqli_fetch_array($result))  
                               {  
                          ?>  
                          <form method="POST">
                              <select name="inv"> 
                               <option><?php echo $row["rizikos_lygis"];?></option>
                               <option value=<?php echo $row["sugeneruoja"]; ?>><?php echo $row["pavadinimas"];?>&nbsp<?php echo $row["sugeneruoja"]; ?></option>
                              </select>
                              <input type="submit" name="submit" value="Apskaičiuoti">    
                          </form>
                          <?php  
                               }  
                          }  
  ?> 
<?php
if(isset($_POST['submit'])){
 echo $row["sugeneruoja"];
}
?>

Edited January 27 by Lukeishen

I have a form that contains 3 text fields and 7 populated lists (that are dependent on the choice of the previous lists).  When I post the information to MySQL and to my processing page, it posts the table "ids" instead of the selected option. 

Here's the php code for the form:

<form action="gccsuccess_form.php" method="post" enctype="multipart/form-data" name="gcc" id="gcc">
  <table width="700" border="0" align="center" cellpadding="3" cellspacing="3">
    <tr>
      <td><label for="date">Today's Date:</label>
 <input type="text" name="date" id="date"></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>Week Number:
       <select name="week" size="1" id="week">
         <option value="0" selected>Week 0 - 3/26 - 4/1</option>
         <option value="1">Week 1 - 4/2 - 4/8</option>
         <option value="2">Week 2 - 4/9 - 4/15</option>
         <option value="3">Week 3 - 4/16 - 4/22</option>
         <option value="4">Week 4 - 4/23 - 4/29</option>
         <option value="5">Week 5 - 4/30 - 5/6</option>
         <option value="6">Week 6 - 5/7 - 5/13</option>
      </select></td>
      <td><label for="location"></label>
      </td>
    </tr>
    <tr>
      <td>Location:
        <select id='locations' name='location'>
      </select></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><label for="label8">Team Name</label>
<select id='team_names' name='team_name'>
</select></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><em>*Please enter each team member's first and last name:</em></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><label for="mem_1"> Team <strong>Captain:</strong></label>
        <select id='team_members 1' name='capt'>
        </select></td>
      <td><label for="label4"><strong>Steps:</strong></label>
        <input type="text" name="steps_1" id="steps_1"></td>
    </tr>
    <tr>
      <td><label for="mem_2">Team Member #2 <strong>Name: 
        <select id='team_members 2' name='mem_2'>
        </select>
      </strong></label></td>
      <td><label for="label5"><strong>Steps:</strong></label>
        <input type="text" name="steps_2" id="steps_2"></td>
    </tr>
    <tr>
      <td><label for="mem_3">Team Member #3 <strong>Name:
            <select id='team_members 3' name='mem_3'>
        </select>
      </strong></label></td>
      <td><label for="label6"><strong>Steps:</strong></label>
        <input type="text" name="steps_3" id="steps_3"></td>
    </tr>
    <tr>
      <td><label for="mem_4">Team Member #4<strong> Name</strong>:
        <select id='team_members 4' name='mem_4'>
        </select>
      </label></td>
      <td><label for="label7"><strong>Steps:</strong></label>
        <input type="text" name="steps_4" id="steps_4"></td>
    </tr>
    <tr>
      <td><label for="label">Team Member #5<strong> Name</strong>:
        <select id='team_members 5' name='mem_5'>
        </select>
      </label></td>
      <td><label for="label7"><strong>Steps:</strong></label>
          <input type="text" name="steps_5" id="steps_5"></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><em>* Maximum steps for each team member per week is <strong>105,000. </strong></em></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="submit" name="Submit Form" id="Submit Form" value="Submit"></td>
    </tr>
  </table>
  <label></label>
  <div align="center"><br>
    If you have questions about the competition or reporting please contact KC   WELLNESS, INC&nbsp;toll free at <SPAN id="lw_1237248942_0">877-634-1412.</SPAN><br>
    <br>
  </div>
</form>


And here's the code for the page it is posted in:

<?php
      
      $date = $_POST['date'];
      $week = $_POST['week'];
      $location = $_POST['location'];
      $team_name = $_POST['team_name'];
      $capt = $_POST['capt'];
      $mem_2 = $_POST['mem_2'];
      $mem_3 = $_POST['mem_3'];
      $mem_4 = $_POST['mem_4'];
      $mem_5 = $_POST['mem_5'];
      $steps_1= $_POST['steps_1'];
      $steps_2= $_POST['steps_2'];
      $steps_3= $_POST['steps_3'];
      $steps_4 = $_POST['steps_4'];
      $steps_5 = $_POST['steps_5'];
      
      mysql_connect("mysql1.myregisteredsite.com", "49200_kandace", "Leonardo56")
      or die(mysql_error());
      mysql_select_db("49200_GCC") or die(mysql_error());
      mysql_query("INSERT INTO `walkathon` VALUES ('$date', '$week', '$location', '$team_name', '$capt','$mem_2','$mem_3',  '$mem_4', '$mem_5', '$steps_1','$steps_2', '$steps_3','$steps_4', '$steps_5' )"); 

      Print "Thank you for your entry. <br>
      Report summary: <br/><br/>";    
      
         echo "<strong> Date: </strong>   {$date} 
         <br/> <br/><strong> Week: </strong>   {$week}
         <br/> <br/><strong> Location: </strong>  {$location}
         <br/> <br/><strong> Team Name: </strong>   {$team_name}
         <br/> <br/><strong> Team Captain: </strong>  {$capt} / <strong> Steps: </strong> {$steps_1} 
         <br /> <br/><strong> Team Member 2 Name: </strong>  {$mem_2} / <strong> Steps: </strong> {$steps_2} 
         <br /> <br/><strong> Team Member 3 Name: </strong>  {$mem_3} / <strong> Steps: </strong> {$steps_3}
         <br /> <br/><strong> Team Member 4 Name: </strong>  {$mem_4} / <strong> Steps: </strong> {$steps_4}
         <br /> <br/><strong> Team Member 5 Name: </strong>  {$mem_5} / <strong> Steps: </strong> {$steps_5}"
         
               ?>

How do I get the processing page to echo the selected option instead of the id?

Not sure exactly where this problem is coming from, but php seems the most likely candidate to fix it.  My php loads, from a MySQL database, a list of names (students in a class) and a drop-down for each student with attendance options.  Based on the information in the database, the appropriate attendance option is selected (<option selected></option>).  Everything works fine on the initial page load. 

Next, I want to update the status, so I select a new option from the drop-down list and click submit.  The php code updates the database correctly, but the selected option (in HTML) is still the original one.  If I change the option to something different and submit again, I get the previously selected option (that I selected the first time) - in essence, the HTML is always one step behind the database.

I've attached the snippet of relevant code - again, I know that the code works when the page loads initially and that the database is getting updated correctly.  Any help or comments are appreciated.

Hi, I have an html form in "send.htm" that sends data to "retrieve.php" with the following structu

send.htm:
Code: [Select]
<html>
<body>

<form method="post" action="retrieve.php"
<select id='select' name='select' >
                        <option>option1</option>
                        <option>option2</option>
                        <option>option3</option>
                        <option>etc...</option>
</select>
<input type="submit">
</form>

</body>
</html>
retrieve.php:
Code: [Select]
<?php

$selectedoption        = $_POST['select']; 

print"

<html>
<body>
<select id='select' name='select' >
                        <option>option1</option>
                        <option>option2</option>
                        <option>option3</option>
                        <option>etc...</option>
</select>
</body>
</html>
";
?>
How do I specify that the select menu in retrieve.php should have the option selected that was chosen from the select menu in send.htm?

I'm guessing this is probably quite straightforward, but I can't quite work it out. Please help!
Thanks.

Hi I have a list of states using the array method in a form. The drop down menu works fine.  I want to save the user choice,if the form is re-displayed due to a blank field or pattern mismatch.  I know I can use the selected=selected, but don't know wher to put the statement:
My array is:
state_province = array ("list of states", "provinces")
Var in my labels array is "state"=>"state"
Here is my code for the select/option statement:

{
 if($field == "state")
   {
      echo "<div class='province_state'><label for='state' size='10'>* Province/State</label><select>";
            
      foreach($state_province as $state)
         {
         echo "\n<option value='$state_province' /> ";   
          echo $state ;
          echo "</option>";
         }
      echo "</select></div>\n";   

   }
?Is this the correct code to add and where would I add  it?
          if(@$_POST['state'] == $value)
     {
         echo "selected='selected'  ";
     }          

The rest of my coding works however this part does not and I'm trying to figure out why. I'm sure my syntax isn't right so I hope someone can correct my mistake.


$contentpageID = $_GET['id'];
    $query = "SELECT  
        contentpages.contentpage, 
        contentpages.shortname,
        contentpages.contentcode,
        contentpages.linebreaks, 
        contentpages.backlink,
        contentpages.showheading,
        contentpages.visible,
        contentpages.template_id
    FROM 
        contentpages
    WHERE 
        contentpages.id = '" . $contentpageID . "'";

<label for="template">Template</label>
                <select class="dropdown" name="template" id="template" title="Template">
                <option value="0">- Select -</option>
                <?php
                $query = 'SELECT * FROM templates';
                $result = mysql_query ( $query );
                while ( $template_row = mysql_fetch_assoc ( $result ) ) {
                        print "<option value=\"".$template_row['id']."\" ";
if($template_row['id'] == $row['template_id']) {
     print " SELECTED";
}
                        print ">".$template_row['templatename']."</option>\r";
                }
                ?>
                </select>

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=333152.0

Hi all,

I have a html drop down menu and want to show the initially selected value as the one stored in the mysql database that a member selected.

I have 180+ rows in mysql that a member could have selected and would like to basically do this:

IF (value of option == $row['value'] ) { echo "selected=\"selected\"; }
I could put this in every one of the rows it would be much better to have an if statement. As there are so many values I do not know where to begin.

Can someone point me in the right direction?

Thanks

Hello I want product filter groups by category.

There will be different options.

Ex: http://prntscr.com/sr00ay

Product Table : http://prntscr.com/sr00rm

Option Groups Table : http://prntscr.com/sr013r

Options Table : http://prntscr.com/sr01fk

Product Option Table : http://prntscr.com/sr01r3

How can I build this structure? And how should it be sql for filtering? Is the structure correct? I'm waiting for your help.

Edited May 31, 2020 by Atakan

So, it's me again.
Hope you dont mind 

I try to fetch data from mysql and list it to select option like this

Code: [Select]
<td>Category</td>
<td>:   <select name="category">
<?php
$query = "SELECT DISTINCT category FROM dress";
$sql = mysql_query($query);
while($result = mysql_fetch_array($sql)){ 
echo "<option value='".$result['category']."'>".$result['category']."</option>";
}
?>
<option value="other">New Category --></option>
</select><input type="text" name="categoryOther"></td>
</tr>

...and success. BUT, when I try to echo submitted value it return nothing
this is the code to process above form
Code: [Select]
if(isset($_POST['categoryOther'])){
$category = $_POST['categoryOther'];
} else {
$category = $_POST['category'];
}
if(isset($_POST['subcategoryOther'])){
$subcategory = $_POST['subcategoryOther'];
} else {
$subcategory = $_POST['subcategory'];
}
echo "category : ".$category."<br>";

What did I do wrong here?

Something is wrong with this drop down form menu.

The name of the option appears and works well however the value does not seem to work.

Any ideas?

Thanks


<?php 
                    include("cxn.php");
                    
                    $query = "SELECT manufacturer FROM list ORDER BY manufacturer ASC"; 
                    $result = mysqli_query($cxn,$query) or die(mysqli_error());
                     
                    ?>
                    <select name="manufacturer" id="manufacturer">
                       <option value="" selected="selected">Select a Manufacturer..</option>";
                    <?php 
                    while($row = mysqli_fetch_row($result)){
                          echo "<option value=\"".$row[0]."\">".$row[0]."</option>"; // SHOWS ALL MANUFACTURERS CURRENTLY ADVERTISED WITH THE NUMBER OF ADVERTS NEXT TO THE MANUFACTURER
                       }
                    ?>

Hi all

I am trying to create a menu that shows the initially selected value depending on which page the user is on:

<?php
$fetchcategories=mysql_query("SELECT * FROM `product_categories` ORDER BY id ASC");
while($returnedcategories=mysql_fetch_array($fetchcategories)) {
echo "<option value=\"".$returnedcategories['name']."\" selected=\"selected\" >".$returnedcategories['name']."</option>";
}
?>

There are three product categories; Stone, Wood and Accessories. in the SQL.

When on the stone.php page I need the option value 'stone' to stay selected.

Many thanks for your help

Pete

I have a test database, I have two names in the database which get returned just fine in my html dropdown. I am trying to figure out how to figure out which item in the list was selected so that I can return information from another table based on the selected id. This is what I am trying now but I don't know how to proceed or if it is correct

Code: [Select]

$result = $mysql->query("SELECT * FROM names") or die($mysql->error);
?>
<select>
<?php
if($result){
while($row = $result->fetch_object()){
$id = $row->nameID;
$name = $row->firstName . " " . $row->lastName;
?>

<option value"<?php $id ?>"><?php echo $name ?></option>

<?php
}?>
</select>
<?php } ?>