Re: [PHP] stumped on mysql_num_rows
On Saturday 14 June 2003 01:55, Global I.S. S.A. wrote: > 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 print out $concatquery to verify that it contains what you expect. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* It's useless to try to hold some people to anything they say while they're madly in love, drunk, or running for office. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] stumped on mysql_num_rows
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"Process anomaly. Please try again.";
>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
