Can you give us the query too? Alex
> Hello List, > The issue appears to be that no rows are being found with mysql_num_rows > using the SQL LIMIT offset. There should be rows found. Further, all > processing just halts, and no query is shown as per the code here: > > > // RUN THE QUERY TO RETRIEVE EACH FOUND RECORD > $queryResultHandle = mysql_query($concatquery, $link_identifier) or die ( > mysql_error()); > // make sure that we recieved some data from our query > $rows = mysql_num_rows ($queryResultHandle); > if ( $rows > 0 ) { // <<<<<<<< THIS IS WHERE THE SCRIPT FAILS > while ($data = mysql_fetch_array ($queryResultHandle)) { > /* ///////////////////////////////////////////////// > // COMMON VARIABLE ASSIGNMENT BLOCK - start > $yflastupdate = $data["lastupdate"]; // and other fields too ... > // COMMON VARIABLE ASSIGNMENT BLOCK - end > //////////////////////////////////////////////////// */ > include("showOneRecord.php"); // display the row values in a > template > } // while > // mysql_free_result ($queryResultHandle); > }else{ > echo"<br>Process anomaly. Please try again.<br>"; > echo $query; > exit; > } > > > The result is intermittent failure with the message "Process anomaly. > Please try again." when the first or subsequent "next page" button is > clicked. No query shown with the failure, and a query should be shown. > > > CONFIGURATION > This issue is experienced intermittently on the developer production site > and "always" on the customer localhost and production sites. The customer > is using "I just recently installed PHP and mySQL so they are pretty close > to the latest versions. I think it's PHP 4.3.1 and mySQL 4.0.13. I get > the same error on both the first time I click the "More Results" button. > My browser is IE 6.0.2800 SP1." > > > What's the problem? > > > Richard > Information Services > Global I.S. S.A. > [EMAIL PROTECTED] > --- > Globalissa B2B Websites > http://phpyellow.com > http://www.dreamriver.com > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php