Drop Down Default Option

Hi

I have coded the following which creates me a database driven drop down menu, however i want to be able have a default option, which is automatically selected based on the value of a varaible.

Any help would be great.

<?php

$query = "select scriptname from script_summary";
$result = mysql_query ($query) or die (mysql_error());
echo "<td><b>Please Select A SCRIPT:</b></td> <td><SELECT name=\"scriptname\">";
if (mysql_num_rows($result)>0)

{
while($row=mysql_fetch_array($result))

{
echo "<option value=\"$row[scriptname]\">$row[scriptname]</option>";
}
}
echo "</SELECT></td>";
?>

Thanks in advance.

I use something like the following, changed to replicate your code but not tested.

PHP: Select all

<select name='scriptname'>
        <?php
do {  
?>
        <option value="<?php echo $row['scriptname']?>"<?php if (!(strcmp($row['scriptname'], $_GET['scriptname']))) {echo "SELECTED";} ?>><?php echo $row['scriptname'];?></option>
        <?php
} while ($row = mysql_fetch_assoc($result));
  $rows = mysql_num_rows($row);
  if($rows > 0) {
      mysql_data_seek($row, 0);
      $row = mysql_fetch_assoc($results);
  }
?>
</select>

PHP manual gives explanation to strcmp and a quick search on [google]mysql_fetch_array v mysql_fetch_assoc[/google] in google returns some results about it being faster for php4 plus.

Cheers mate, i got it working.