Select Box's and arrays

[xydon1]

I am running a query to get a list of company names. What I need is an array that will still populate my select box with the company names from my database, but will select the entry $seleted, if it is the record in question. Can anyone help?

<option value="0">Please Select A Company
$company=mysql_query("select distinct companyName from auth");
while (list($companyName)=mysql_fetch_row($company))
{
?>
<option value="<?echo $companyName; ?>" <?echo $selected;?>><?echo $companyName; ?></option>
<?
}
?>
<option value="new">New Company Name
</select>

[AstroTeg]

Let me see if I got this straight:

You have a list box. You want to load the list box with contents from a query, but have default selected the user's selection. This correct?

[xydon1]

Hey thanks for the speedy reply!!!

Well what this is, is a form that is updating a record previously entered. The select box is a query from the database with all my company names in it. I am running above a query to get the record in question:

<?
$contractGet=mysql_query("select contractName,companyName,dateAdded from contracts where recordID=$editContract");
while (list($recordID,$contractName,$companyName,$dateAdded)=mysql_fetch_row($contractGet))
{
?>
$editContract is the record ID

I need the select box to be populated with the $company name that the recordID is from see image http://www.xydon.com/query.gif

I apologize for not being to explaing this better.