[Resolved] Select <options>

[rcoursey]

I have been thru this a little before. Someone posted code that I am now trying to use while retrieving information from a MySQL DB into an HTML SELECT element. The code is supposed to check the value from the related table field and print selected in the <OPTION> tag so the info will be displayed as the default item in the box.

The code as I have ammended is:

<option <?php echo $state=='AL'?'selected':'';?> value="AL">Alabama</option>

Am I doing this the right way because the info is not showing up. Could it be the ' instead of "?

Richard

[leatherback]

Hi,

You are missing a " after echo.

J.

[rcoursey]

Should the " go after the echo and at the end:

ie.

<option <?php echo "$state=='AL'?'selected':'';?"> value="AL">Alabama</option>

The marks after 'selected': are single quotes indicating a blankentry.

[cosminb]

are you sure $state isn't empty???
because your example si working fine with me
here is what i did:

<?php
$state='AL';
?>
<select>
<option <?php echo $state=='AL'?'selected':'';?> value="AL">Alabama</option>
<option <?php echo $state=='blabla'?'selected':'';?> value="blabla">BLABLA</option>
</select>

and here is the output:

<select>
<option selected value="AL">Alabama</option> 
<option  value="blabla">BLABLA</option> 
</select>

[rcoursey]

The above works well if you assign the state to value. But if you need dynamic selects based on info in database then it has drawbacks.

I found my error in coding in the first post. The correct and working code is:

<option <?php echo $row['state']=='AL'?'selected':'';?> value="AL">Alabama</option>

I needed to get the record info and compare that the value for each option to see if the value was selected.

Thanks

[cosminb]

😕
... well i assumed that $state wasn't empty ...

[rcoursey]

I realize that I did not make the issue clear enough. state is the variable but it is the field I was after. I went thru one other revision before I realized I was trying to retrieve the info the wrong way.

Sorry & Thanks again for the input. It does help!