All the records from the table

[Anon]

I am trying to update and then display the records on a form.But, unfortunately, i am able to get only one record, that is the last entered record from the table.What should i do if i want to display all the records.

Herez my code:

<?php

$sql ='update statement';
$result = ibase_query($connection, $sql);

$db='select statement';
$bsc= ibase_query($connection, $db);
while ($row = ibase_fetch_object($bsc)) {

here all my fields;

}
?>

Now, could somebody please tell me how to display all the records from my table.

thank you in advance

[bastien]

$sql = "select * from table";

hth
bastien