Editing drop down list with PHP-Mysql

[mpempas]

Hello,

 

Ive found this code by google

 

			<select name="user_position" id="user_position" class='textbox'>
				<?php 
				foreach($user_position as $key => $value) {
						if($_SESSION['user_position'] < $key) {
							$selected = '';
							if($key == $row['user_position']) {
								$selected = ' selected="selected"';
							}
							echo('<option value="'.$key.'"'.$selected.'>'.$value.'</option>');
						}		
					}
				?> 
			</select> </td>

 

But i cant make it work, i want im going to edit a user profile to 'auto' select the existing choice i have on the database ..

Any help please?

 

Thank you

[taquitosensei]

There's a few things.  You don't need the if($_SESSION['user_position'] < $key

You don't need the parenthesis around your echo. And if you're going to concatenate the variables/ html for output your quotes aren't right.

<select name="user_position" id="user_position" class='textbox'>
               <select name="user_position" id="user_position" class='textbox'>
               <?php 
               foreach($user_position as $key => $value) {
                        $selected = '';
                        if($key == $row['user_position']) {
                          $selected = "selected='selected'";
                        echo "<option value='".$key."'".$selected.">".$value."</option>";
                     }      
                  }
               ?>
            </select> </td>
              
           

[mpempas]

$user_position = array (
	1 => 'test drop-down 1',
	2 => 'test drop-down 2',
	3 => 'test drop-down 3'
);

Edided code:

<select name="user_position" id="user_position" class='textbox'>
               <select name="user_position" id="user_position" class='textbox'>
               <?php 
               foreach($user_position as $key => $value) {
                        $selected = '';
                        if($key == $row['user_position']) {
                          $selected = "selected='selected'";
                        echo "<option value='".$key."'".$selected.">".$value."</option>";
                     }      
                  }
               ?>
            </select> </td>

 

If i use the above fixed code its not even has a drop down list..

[taquitosensei]

Because I screwed up and had a bracket out of place try this

               foreach($user_position as $key => $value) {
                        $selected = '';
                        if($key == $row['user_position']) {
                          $selected = "selected='selected'";
                        }
                        echo "<option value='".$key."'".$selected.">".$value."</option>";   
                  }

also that tells me that $key never equals $row['user_position']  otherwise you would have had a single option. The default one.

[mpempas]

again no luck .. its display the first in the list not the corrent is in the database

[taquitosensei]

try this.  Copy and paste the results.

<!--<select name="user_position" id="user_position" class='textbox'>-->
               <?php 
               foreach($user_position as $key => $value) {
                echo "key: ".$key.", value: ".$value.",   user_position:".$row['user_position']."<br>"
                        $selected = '';
                        if($key == $row['user_position']) {
                           $selected = ' selected="selected"';
                        }
                        <!--echo '<option value='".$key."'".$selected.">".$value."</option>-->";   
                  }
               ?>
            <!--</select>--> </td>

[mpempas]

Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';'  (line 52)

 

<!--<select name="user_position" id="user_position" class='textbox'>-->
               <?php 
               foreach($user_position as $key => $value) {
                echo "key: ".$key.", value: ".$value.",   user_position:".$row['user_position']."<br>"
                        $selected = ''; <--------------------------------
                        if($key == $row['user_position']) {
                           $selected = ' selected="selected"';
                        }
                        <!--echo '<option value='".$key."".$selected.">".$value."</option>-->";   
                  }
               ?>
            <!--</select>--> </td>

[Hybride]

Change

 echo "key: ".$key.", value: ".$value.",   user_position:".$row['user_position']."<br>"

to

 echo "key: ".$key.", value: ".$value.",   user_position:".$row['user_position']."<br>";

 

You were missing a semi-colon at the end.

[mpempas]

Parse error: syntax error, unexpected '<' in (line 56)

 

<!--<select name="user_position" id="user_position" class='textbox'>-->
               <?php 
               foreach($user_position as $key => $value) {
echo "key: ".$key.", value: ".$value.",   user_position:".$row['user_position']."<br>";
                         $selected = '';
                        if($key == $row['user_position']) {
                           $selected = ' selected="selected"';
                        }
                        <!--echo '<option value='".$key."".$selected.">".$value."</option>-->";   <-----------------------------
                  }
               ?>
            <!--</select>--> </td>

[taquitosensei]

I guess I wasn't at the top of my game when I posted that.  :-\

  <?php 
               foreach($user_position as $key => $value) {
echo "key: ".$key.", value: ".$value.",   user_position:".$row['user_position']."<br>";
                         $selected = '';
                        if($key == $row['user_position']) {
                           $selected = ' selected="selected"';
                        }
                        // echo '<option value='".$key."'".$selected.">".$value."</option>";   
                  }
               ?>

there was also a single apostrophe missing after $key in the same line.