PHP Select Box and default Value 1

[pastorandy]

I have this which pulls a country select box:

<?
$query_country  = "SELECT * FROM country";
$result_country =  mysql_query($query_country) or die (mysql_error());

 echo "<select name = country>"; 
     
     while ($row2 = mysql_fetch_array($result_country)) 
	 echo "<option value = '$row2[country_name]'>$row2[country_name]</option>";
        }
	 
	 } echo "</select>";
?>

How would I set a default country?

 

[jpadie]

<?
[red]$defaultCountry = 'GB';[/red]
$query_country  = "SELECT * FROM country";
$result_country =  mysql_query($query_country) or die (mysql_error());

echo "<select name=[red]\"country\"[/red]>"; 

while ($row2 = mysql_fetch_array($result_country)) [red]:[/red]
   [red]$country = htmlspecialchars($country);
   $selected = $defaultCountry ==$country  ? 'selected="selected"' : '';[/red]
   echo "<option value=[red]\"$country" $selected[/red] >$country</option>";
endwhile;
 
echo "</select>";
?>

 

[pastorandy]

Thanks jpadie. Just worked out who you are )
How bizarre is that?

Andy

 

[pastorandy]

JP
Not working for me. No list displayed. Is it something to do with the country being country_name?

 

[jpadie]

good to see you back at TT, Andy.

well, you need to specify defaultCountry to something that is actually in the list. note that it needs to be the right caps etc. i assume that's not the problem though ...

and also this line is wrong (correct as shown)

$country = htmlspecialchars([red]$row2['country_name'][/red]);

 

[pastorandy]

Just been tweaking it and go this to work:

<?
$default_country = 'United Kingdom';
$query_country  = "SELECT * FROM country";
$result_country =  mysql_query($query_country) or die (mysql_error());

 echo "<select name = country>"; 
     
     while ($row2 = mysql_fetch_array($result_country)) 
	 {
 $selected = $default_country ==$row2['country_name']  ? 'selected="selected"' : '';
  echo "<option value = '$row2[country_name]' $selected>$row2[country_name]</option>";
           
     } echo "</select>";
?>

 

[dagoat10]

i have the same problem

echo "<table border = '5'>";
echo "<tr>";
echo "<form name='Set' method='post' action='Set_Team.php'>";
echo "<td>";
echo "<table border = '0'>";
while($row = mysql_fetch_array($data))
{
    $ID = $row['ID'];
    echo "<tr>";
    echo "<td>";
    echo $row['Player'];
    echo "</td>";
    echo "<td>";
    echo "<select name='$ID'>";
    echo "<option name='Start'>Start</option>";
    echo "<option name='Sit'>Sit</option>";
    echo "</select>";
    echo "</td>";
    echo "</tr>";
}

echo "</table>";
echo "<center>";
echo "<input type='hidden' name='TN' value=$TeamName />";
echo "<input type='submit' name='Set' value='Set Players' />";
echo "</td>";
echo "</tr>";
echo "</form>";
echo "</table>";

$setquery="SELECT * from $TeamName";
$setdata=mysql_query($setquery);

while($setrow = mysql_fetch_array($setdata))
{
    $Set=$setrow['ID'];
    //echo $Set;
    //echo $_POST[$Set];
    $setquery2 = "UPDATE $TeamName set Start_Sit=$_POST[$Set] where ID=$Set";
    mysql_query($setquery2);
    mysql_error();
}

but when i try to set the option value to what the value is in the table it does not stay it always says "Start" even if i select "Sit"

what am i doing wrong?

 

[jpadie]

you are setting the name of a select box to an id. that is unlikely to be a good idea.
you are not setting the select attribute nor testing the value of the relevant database field against the value of the relevant select option.

 

[dagoat10]

I see now I would need to have the value as selected when retrieving the value from the database