inconsistent select query performance

[Anon]

Hello All, 15th January 2001
In my php3 to oracle programs,
when I insert data the retreival is erratic.like if I have inserted 28 rows,the select queries output(via php3) shows 5 rows sometimes and sometimes 10 rows,some times 0 records etc...
can anyone tell me what database fine tuning needs to be
done to rectify this????
Or is there any problem in my code
I am doing a select * and then a while list key,val = fetch_row

Regards,
Soumitra

[jblallement]

Hi,

Can you cut and past your code here please.

[Anon]

$query = "SELECT * from cmastertest ";

print "<TABLE BORDER=\"1\">\n";
//print "<TR>\n";
while ( list( $key, $val ) = fetch_row( $sth ) ) {
print "<TR>";

print "<TD>key is $key</TD>";

print "<TD>val is $val</TD>";

print "</TR>";

}

there are 28 rows in cmastertest
but output is sometimes 5 rows,sometimes no rows,sometimes 1 row etc.....

I there any oracle fine tuning to be done????

[jblallement]

What's this fetch_row function ?