Hi all,
let's figure we have one big database table ~1mln rows.
I can easly to collect needed data from this table with query:
SELECT id,title,cdate FROM bigtable WHERE active ORDER BY cdate ASC,
id ASC LIMIT 300,100
So i get needed rows to display.
i can make easly with page numbers to
with same WHERE and
ORDER.
so i never know page number.
:)
RB Vaidas Zilionis wrote:
RB [...]
Example items are displayed 100 in page, and i display 20 pages
numbers
1 ... 4[5] 6 x
doomain.con/items.php?page=5
and i get all result here with limit 400,100
RB Yes, with PHP it would be something
to to simple trick, SelectRowWhereId(1525)
VZ script must now position of that row in database with same WHERE and
VZ ORDER.
VZ so i never know page number.
VZ :)
RB Vaidas Zilionis wrote:
RB [...]
Example items are displayed 100 in page, and i display 20 pages
numbers
1 ... 4[5] 6 x
, count(s.id) as sk from rajonai as r, sodybos as s WHERE
s.rajonai_id = r.id group by r.id
It's work good, but I can't get rows which count(s.id) = 0
Example with 1 query I get
1|12
2|0
3|15
4|5
5|1
With second only
1|12
3|15
4|5
5|1
How to get and 2 row? Which count result = 0
--
Vaidas