Form Class ADOdb Code Conversion Problem

i have the following code that i need to decipher and
put into an adodb format.

$options=array(""=>"Select an user");
while($row=database_fetch_row($result))
  $options[$row[0]]=$row[1];

i thought this would work...

$options=array(""=>"Select an user");
while (!$rs->EOF) {
$options[$fields[0]]=$fields[1];
$rs->MoveNext();}

but it didn't.

the bottom line is i am trying to get ADOdb to create
an array where each array element conists of 2 values
- the customer_id and the the customer_name
(fields(0), fields(1)).  I pull these from the
database.

i'm using manuel lemos' form class.  when i get the
array $options set up right, i should be able to plug
it into lemos' form declaration and it should populate
my list box.

how can i use adodb to set such an array up?

tia...



__________________________________
Do you Yahoo!?
Plan great trips with Yahoo! Travel: Now over 17,000 guides!
http://travel.yahoo.com/p-travelguide