Populating a Drop down field

[Jon12345]

I have a drop down field on edit.php, which lets me edit a list of data for one record. The status field has 3 values: Not Started, Pending, or Finished.

I've been trying to get this to work:

[code]<? if ($row['review']="Not Started") { echo "<option selected>"; } else {echo "<option>"; } ?>Not Started</option>
<? if ($row['review']="Pending") { echo "<option selected>"; } else {echo "<option>"; } ?>Pending</option>[/code]

Any suggestions on what best practice is in this area?

Thanks,

Jon

[Psycho]

You need to use double equal signs in if statements - unless you are trying to assing a value. Here is another approach:

[code]
<?php
echo "<option" . (($row['review']=="Not Started")?" selected":"") . ">Not Started</option>";
echo "<option" . (($row['review']=="Pending")?" selected":"") . ">Pending</option>";
?>
[/code]

[Jon12345]

Oh that is nicely efficient. Thank you!

[Jon12345]

Actually, that doesn't seem to be working. Now I see no values in the drop down box. Is it a syntax thing?

[sanfly]

How about this

[code=php:0]<option <? if($row['review'] == "Not Started"){ echo "selected";}?>>Not Started
<option <? if($row['review'] == "Selected"){ echo "selected";}?>>Selected[/code]

The main problem with your original script was you had only a single = not == in your if statement

[Jon12345]

That did the trick. Thank you.

[sanfly]

Great :)

Edit your original post and put *SOLVED* in the title