php - Wrong result with FOUND_ROWS() in mySQL -

-

i have total of 6 rows. when query (say select * table) , have

  • limit 3 => found_rows() gives 3 => 3 rows retrieved
  • limit 1, 3 => found_rows() gives 4 => 3 rows retrieved
  • limit 2, 3 => found_rows() gives 5 => 3 rows retrieved
  • limit 3, 3 => found_rows() gives 6 => 3 rows retrieved
  • limit 4, 3 => found_rows() gives 6 => 2 rows retrieved

any idea cause of weird behavior?

sql query

select `places`.*, `category`.*, count(places_reviews.place_id) num_reviews, (places_popularity.rating_1 + 2*places_popularity.rating_2 + 3*places_popularity.rating_3 + 4*places_popularity.rating_4 + 5*places_popularity.rating_5)/(places_popularity.rating_1 + places_popularity.rating_2 + places_popularity.rating_3 + places_popularity.rating_4 + places_popularity.rating_5) average_rating, found_rows() num_rows (`places`) join `category` on `places`.`category_id` = `category`.`category_id` left join `places_reviews` on `places_reviews`.`place_id` = `places`.`id` left join `places_popularity` on `places_popularity`.`place_id` = `places`.`id` `places`.`category_id` = 1 , `places`.`name` '%%' group `places`.`id` order `id` desc limit 3

or in block:

select `places`.*, `category`.*,  count(places_reviews.place_id) num_reviews,  (places_popularity.rating_1 + 2*places_popularity.rating_2 + 3*places_popularity.rating_3 + 4*places_popularity.rating_4 + 5*places_popularity.rating_5)/(places_popularity.rating_1 + places_popularity.rating_2 + places_popularity.rating_3 + places_popularity.rating_4 + places_popularity.rating_5) average_rating, found_rows() num_rows (`places`)  join `category` on `places`.`category_id` = `category`.`category_id`  left join `places_reviews` on `places_reviews`.`place_id` = `places`.`id`  left join `places_popularity` on `places_popularity`.`place_id` = `places`.`id`  `places`.`category_id` = 1      , `places`.`name` '%%'  group `places`.`id`  order `id` desc limit 3

edit :

this looking : http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_found-rows

so in query :

select sql_calc_found_rows .....


Comments

Post a Comment

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -

-
pypdf throws exception: pypdf.utils.pdfreaderror: eof marker not found i don't need fix pypdf, need eof error cause "except" block execute , skip on file, doesn't work. still causes program stop running. background: batch ocr program pdfs python, pypdf, adobe pdf ocr error: unsupported filter /lzwdecode ... saga continues. i got 10,000 pdfs in folder. ocrd, not. can't tell 'em apart. step 1 figure out ones not ocrd , ocr (see other threads details). so i'm using pypdf. exceptions related unrecognized characters , unsupported filters when try read text. guestimated if throws exception, it's got text in , doens't go in list. problem solved, right? so: pypdf import pdffilewriter, pdffilereader import sys, os, pypdf, re path = 'c:\users\homer\documents\my pdfs' filelist = os.listdir(path) has_text_list = [] does_not_have_text_list = [] pdf_name in filelist: pdf_file
Read more