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
