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

Cursor error with postgresql, pgpool and php -

-
hey, struggling bit determine exact cause of error has been popping in our release environment. there not seem dealing particular error on google. this error message getting: sqlstate[34000]: invalid cursor name: 7 error: portal "" not exist the error pops when using pdo prepared statements. this setup our release environment: pgpool 3.0.1 (the postgresql backend in streaming replication mode!) php 5.3.5 postgresql 9.0 edit: architecture 64bit. the same error not manifest in our test environment (edit: forgot mention, standard test environment uses postgresql 9.0 without pgpool). thus, led suspect pgpool @ least partly suspect. does know probable causes error are? edit: ok, here example of kind of code causes error. $sql = 'select * '; $sql .= 'from "mytable" "mystuff" '; $sql .= 'where "mytable"."status" = 1 '; $sql .= 'and "mytable"."mytableid" = :table...
Read more

delphi - ESC/P programming! -

-
why need use because printers using tprinter prints weird hieroglyph @ beginning of printable area. my problem if send commands, nothing happens. esc e (#27 #69) - sending escape sequence didn't work expected. removed first letter , rest of string made bold. eg. hello -> ello . after changed esc e esc (#27 #69 #27), worked fine. example managed figure out, but... trying select character table "esc t n" (#27 #116 n), make "õäöü" work. command doesn't work. nothing happens! , command supported esc/p, esc/p 2 , 9-pin esc/p, should work fine. manual can found here . if has ever needed use esc/p commands maybe 1 can shed light how work them! thanks in advance! edit: in previous post asked more or less same question though answers how did send commands printer. (i'll change question there according answers!) i accepted ken's answer, because claimed way transferred commands wasn't best , got work escape command. problem after t...
Read more

c++ - error: use of deleted function -

-
i've been working on c++ code friend has written , following error have never seen before when compiling gcc4.6: error: use of deleted function ‘gamefsm_<std::array<c, 2ul> >::hdealt::hdealt()’ implicitly deleted because default definition ill-formed: uninitialized non-static const member ‘const h_t floppokergamefsm_<std::array<c, 2ul> >::hdealt::h’ edit: comes part of code using boost msm: boost webpage edit2: there no = delete() used anywhere in sourcecode. generally speaking, error mean? should looking when type of error occurs? i don't think other answers mentioning =deleted; syntax correct. error message says default constructor has been deleted implicitly . says why: class contains non-static, const variable, not initialized default ctor. class x { const int x; }; since x::x const , must initialized -- default ctor wouldn't initialize (because it's pod type). therefore, default ctor, need define 1 (and must ...
Read more