Php, Html selected Issue

Question

Following is my Php code where all country come from mysql database. It's a user profile area where users can update their country name. But it's not selected (html selected = selected) after he submit his country name. May be it's my $sel variable problem. Can some one fix it ?

<select name="country" class="country"> 
<?php
$sql=mysql_query("select * from country");
while($row=mysql_fetch_array($sql))
{
$id=$row['Code'];
$data=$row['Name'];

    if($data == $country2)
    {
        $sel = 'selected = "selected"';
    }
    else
    {
        $sel = "";
    }

echo '<option value="'.$id.'" $sel>'.$data.'</option>';
}
?>
</select>

jasonbar · Accepted Answer · 2013-01-20 14:15:53Z

4

Variables are not parsed inside of single quotes. You use concatenation for the other variables in your statement, but not $sel...

echo '<option value="'.$id.'"' . $sel . '>'.$data.'</option>';

Or switch to double quotes..

answered Jan 20, 2013 at 14:15

jasonbar

13.5k4 gold badges41 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Roopendra · Accepted Answer · 2013-01-20 14:16:58Z

1

Please try this:-

<select name="country" class="country"> 
<?php
$sql=mysql_query("select * from country");
while($row=mysql_fetch_array($sql))
{
$id=$row['Code'];
$data=$row['Name'];

    if($data == $country2)
    {
        $sel = 'selected = "selected"';
    }
    else
    {
        $sel = "";
    }

echo '<option value="'.$id.'"' . $sel . '>'.$data.'</option>';
}
?>
</select>

answered Jan 20, 2013 at 14:16

Roopendra

7,77716 gold badges72 silver badges95 bronze badges

Comments

tvkanters · Accepted Answer · 2013-01-20 14:16:27Z

0

In PHP, strings in single quotes will not have the variables in their content parsed. $sel will therefore be printed just like that. Either use $sel separately ('<option value="'.$id.'" '.$sel.'>') or use double quotes ("<option value=\"$id\" $sel>").

answered Jan 20, 2013 at 14:16

tvkanters

3,5214 gold badges32 silver badges47 bronze badges

Collectives™ on Stack Overflow

Php, Html selected Issue

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related