update form help

ajsharp

I have created an update form which is all working as the fucntions its self . But i have a problem with selecting the data to update

I have created a drop down menus that populates from mysql this is on the insert form

but i need it too appear on the update form whilst also echo the records selected value .
<? echo $rows['vetid']; ?> that its how ive done for the values with no drop down box

[CODE]select name="animalid">
    <?

$query=("select * from animals");

$result=mysql_query($query) or die ("Unable to Make the Query:" . mysql_error() );

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

echo "<OPTION VALUE=".$row['animalid'].">".$row['animal']."</OPTION>";
}
?>[/CODE]

so is it possible to merge theese two bits of code together .

Thanks

messels

hmm, i'm still a n00b but i'd suggest trying:

$row_count=mysql_num_rows($result)
if ($row_count > 0)
{
$int = 0
while (int<=$row_count)
{
//echo your options through the loop; i'm not goign to bother writing this out because i don't know the flow of your code enough to guess
int++; //increment the int to go against the row_count again
} //end while
} //end if