Selection in drop down list

[liteon]

Aloha,

The partly script below read a database content and create a drop down list, prior to that part I have a variable $choose, how can I make one of the selection as the selected one which will be the same content as $choose.

Script:
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'snake';
$table = 'main';

          $link = mysql_connect($host,$user,$pass);
          if(!$link) die(mysql_error());
          $select = mysql_select_db($db);
          if(!$select) die(mysql_error());

          $query = "SELECT DISTINCT species FROM main ORDER BY species";
          $result = mysql_query($query);
          if(!$result) die(mysql_error());
          /*echo "<select name=\"species\">\n";
          echo "<option value=\"\"> </option>\n";*/
          while($row = mysql_fetch_array($result))
          {
          echo "<option value='".$row['species']."'>".$row['species']."</option>\n";
          }
          echo "</select>\n";

[nnichols]

Try this -

<?

$host = 'localhost'; 
$user = 'root'; 
$pass = ''; 
$db = 'snake'; 
$table = 'main'; 

$link = mysql_connect($host,$user,$pass); 
if(!$link) die(mysql_error()); 
$select = mysql_select_db($db); 
if(!$select) die(mysql_error()); 

$query = "SELECT DISTINCT species FROM main ORDER BY species"; 
$result = mysql_query($query); 
if(!$result) die(mysql_error()); 
echo "<select name=\"species\">\n"; 
echo "<option value=\"\"> </option>\n";
while($row = mysql_fetch_array($result))
{
// added this
if ($choose == $row['species'])
	$selected = ' selected';
else
	$selected = '';

echo "<option value='".$row['species']."'$selected>".$row['species']."</option>\n"; 
} 
echo "</select>\n";

?>

Hope this helps 😉

[volleytotal_ch]

while($row = mysql_fetch_array($result)) 
{ 
  echo "<option value='".$row['species']."'";
  if(strcmp($row['species'],$choose)==0)
    echo " selected";
  echo ">".$row['species']."</option>\n"; 
} 

[liteon]

I add nnichols add-on and it works only with Netscape 7.0 but not with IE 6, anyone as an idea why?

In IE the field’s content is outside the drop down list.

[nnichols]

Can you post a couple of lines of the HTML for the <SELECT> that is produced by the script.

[nnichols]

Try changing the code to this -

echo "<option value=\"" . $row['species'] . "\" $selected>" . $row['species'] . "</option>\n";

It shouldn't make a difference but try it anyway.

[liteon]

Thanks a lot for the help, I had a duplicate <select name...

Thanks again

[nnichols]

Don't duplicate it. Change the syntax to -

$result = mysql_query($query)
    or die(mysql_error()); 
echo "<select name=\"species\">\n";