[RESOLVED] Dropdown issue

[lerro]

How do i get a drop-down list that is populated from the database to work?

If the drop-down i like this

  <label>Item
     <select name="record_status"   value="<?php echo set_value('record_status',"$row->record_status"); ?>"  selected="selected">
       <option value="">----------------------</option>
       <option value="active">Active</option>
       <option value="inactive">Inactive</option>
              </select>
  </label>

It doesn't work well as the result when php is processed is this;

<label>Item
     <select name="record_status"   value="active"  selected="selected">
       <option value="">----------------------</option>
       <option value="active">Active</option>
       <option value="inactive">Inactive</option>
              </select>
  </label>

Yet it should be something like this

<label>Item
     <select name="record_status"  >
       <option value="">----------------------</option>
       <option value="active" selected="selected" >Active</option>
       <option value="inactive">Inactive</option>
              </select>
  </label>

How do i achieve that?

[bradgrafelman]

lerro wrote:

How do i achieve that?

By moving the appropriate PHP code from the <select> tag into the loop that outputs the <option> tags, of course.

[lerro]

How would the loop then detect to know the value of "record_status" before outputting it? so that it does not repeat that value while looping?

Otherwise, if "active" was the selected value, then the drop-down might end up with

active
active
Inactive

[lerro]

I have this code

		echo '<option value="'.$value.(($value==$row->record_status) ?  'selected="selected"' : '').'">'.$name.'</option>'

But i get this as the output

<option value="">----------------</option><option value="active">Active</option><option value="inactiveselected="selected"">Inactive</option>

Where is the fault in the above code? it seems an apostrophe is misplaced or missing, therefore causing this error where inactive has no closing apostrophe and then two closing apostrophes at the end when php is processed

value="inactiveselected="selected"">

[bradgrafelman]

You placed the PHP code for echo'ing selected="selected" (if necessary) before the closing quote for the value attribute.

[lerro]

I've tried moving the apostrophes into all possible possitions, nothing will work. Can you please show me an example of how it should be placed correctly.

[lerro]

It's okay, i resolved the issue with something else

    /*** loop over the results ***/
    foreach($result as $row)
    {
        /*** create the options ***/
        echo '<option value="'.$row['atomicnumber'].'"';
        if($row['atomicnumber']==42)
        {
            echo ' selected';
        }
        echo '>'. $row['english'] . '</option>'."\n";
    }