[CutAndPaste]

Hi,

I'm using the following include to return a list of companies in from a directory listing database. This list is used in an online ofrm and is NOT linked to the db in any other way.

It all works great. BUT what I'd like is to allow a "Not Applicable" to be the default option in this list. Is this possible and how would I do it?

Code:

<?
error_reporting( E_ERROR | E_PARSE );

require_once( 'conf/config.inc.php'  );
require_once( 'mysql.class.php' );


//-------------------------------------


$oDb = new MySQL( $aCfg['db_host'], $aCfg['db_name'], $aCfg['db_user'], $aCfg['db_pass'], true );

$sList = '';

if ( $oDb->Connect() )
{
   $hQRes = $oDb->ExecQuery( "SELECT {$aCfg['db_field']} AS fld_alias FROM {$aCfg['db_table']} where firmstate='on' ORDER by {$aCfg['db_field']}" );
   while ( $aRes = $oDb->FetchArray($hQRes) )
   {
      $sTmp = addslashes( $aRes['fld_alias'] );
      $sList .= "<option value='$sTmp'>$sTmp</option>\n";
   }
   echo $sList;
}
else
{
//   print_r( $oDb->aErrors[count($oDb->aErrors)-1] );
}

?>[

Thanks,

Simon