Select Option box to display data from table

[josephbupe]

Hi,

 

How can I use the select option box to display an option value saved to a table and use the same select box to also select any other value If I want to change the saved value?

 

 

[abrahamgarcia27]

Check this sample

 

 <p>
                          <label>State</label>
                        <span class="formwrapper">
                        <select data-placeholder="Choose a State..." name="state" class="chzn-select" tabindex="2">
                        <?php 
                        $state_list = array('AL'=>"Alabama",
                            'AK'=>"Alaska",  
                            'AZ'=>"Arizona",  
                            'AR'=>"Arkansas",  
                            'CA'=>"California",  
                            'CO'=>"Colorado",  
                            'CT'=>"Connecticut",  
                            'DE'=>"Delaware",  
                            'DC'=>"District Of Columbia",  
                            'FL'=>"Florida",  
                            'GA'=>"Georgia",  
                            'HI'=>"Hawaii",  
                            'ID'=>"Idaho",  
                            'IL'=>"Illinois",  
                            'IN'=>"Indiana",  
                            'IA'=>"Iowa",  
                            'KS'=>"Kansas",  
                            'KY'=>"Kentucky",  
                            'LA'=>"Louisiana",  
                            'ME'=>"Maine",  
                            'MD'=>"Maryland",  
                            'MA'=>"Massachusetts",  
                            'MI'=>"Michigan",  
                            'MN'=>"Minnesota",  
                            'MS'=>"Mississippi",  
                            'MO'=>"Missouri",  
                            'MT'=>"Montana",
                            'NE'=>"Nebraska",
                            'NV'=>"Nevada",
                            'NH'=>"New Hampshire",
                            'NJ'=>"New Jersey",
                            'NM'=>"New Mexico",
                            'NY'=>"New York",
                            'NC'=>"North Carolina",
                            'ND'=>"North Dakota",
                            'OH'=>"Ohio",  
                            'OK'=>"Oklahoma",  
                            'OR'=>"Oregon",  
                            'PA'=>"Pennsylvania",  
                            'RI'=>"Rhode Island",  
                            'SC'=>"South Carolina",  
                            'SD'=>"South Dakota",
                            'TN'=>"Tennessee",  
                            'TX'=>"Texas",  
                            'UT'=>"Utah",  
                            'VT'=>"Vermont",  
                            'VA'=>"Virginia",  
                            'WA'=>"Washington",  
                            'WV'=>"West Virginia",  
                            'WI'=>"Wisconsin",  
                            'WY'=>"Wyoming");
                        foreach ($state_list as $key => $value) {
                        ?>
                        <option value="<?php echo $key; ?>" <?php if($record['state'] == $key)echo "selected";?>><? echo $value; ?></option> 
                        <?php } ?>
                        </select>
                        </span>
                        </p>

[josephbupe]

I will try that.

 

Thanx.

[josephbupe]

Hi,

 

I meant for categories in another table, unlike in your case where the list is hard coded.

[DaveyK]

so you fill the array with the content from a table using SQL