Oracle record counting

I'm attempting to work on a little oracle search... My problem is that if I put the OCIExecute BEFORE the OCIFetchStatement line, I get one error ( Warning: OCIFetchInto: ORA-01002: fetch out of sequence in d:\InetPub\wwwroot\etc. ) but if I put OCIExecute AFTER the OCIFetchStatement I get a different error (Warning: OCIFetchStatement: ORA-24338: statement handle not executed in ). In this order: OCIExecute ( $stmt_search , OCI_DEFAULT ); $nrows = OCIFetchStatement( $stmt_search , $results ); echo "<P>There are $nrows records containing your criteria.</P>"; I get the number of records, but the I don't get the reords listed. In this order: $nrows = OCIFetchStatement( $stmt_search , $results ); echo "<P>There are $nrows records containing your criteria.</P>"; OCIExecute ( $stmt_search , OCI_DEFAULT ); I get the list of records, but no amount of records... I tried running a reset( $results); on it but that didn't seem to help... Can someone help? Oracle 8.1.6 client (7.3.4 server) NT4 IIS4 PHP 4.0.4 CGI Thanks, John --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - NEW FEATURES ADDED DAILY! Licking County, Ohio, USA 740-349-3631 Aut insanit homo, aut versus facit