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
