Hello i want to select from database looks like this (id, nickname)
id is unique and nickname can be input many times, i select rows from base something like this
select from my_table order by id desc limit 0,20
start of limit changing by the page.
But now i want to change row select. I want to select 20 rows but with condition that withdraw only 4 rows for one nick per page (per 20 rows).
I don't understand how can i make it.
10-16-2011, 01:05 AM
Mmm, do you mind re phrasing your post? I don't understand what you need done.
10-16-2011, 04:12 AM
i have a column "nickname" and i need to make a query which will withdraw 20 rows, in this query i need to withdraw only 4 rows per one nickname(or lower than 4 rows by 1 nickname)