how to read $result a second time

[bloomoon]

I have ran an SQL on my database and created a $result variable.
My HTML page consists of a form with ten menus. I have populated my first menu successfully by inserting this code:

while ($row = ibase_fetch_object ($result)) {
$appid = $row->APPLICATION_ID;
if($appid == 1){
echo "<option>";
echo $row->VERSION_NUMBER;
echo "</option>";
}
}

i thought i could repeat this code for the second menu replacing line 3 with:

if($appid == 2){

but the second menu is not getting populated. i have tried using the "ibase_free_result function" and i have also tried starting my second menu code with "$row=0" thinking this would start the query off from row 1 again. why can i not query my $result a second time in order to populate my second menu?

[bloomoon]

sorry for wasting your time! i have solved this by inserting the following line in front of my second menu code:

$result = ibase_query ($tr, $sql);