From: Abs (absque3yahoo.co.uk)
Date: Sat Dec 27 2003 - 08:08:08 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

hi
i was trying to group my results 10 per page ($p per
per page). if i use limit, then there's no way of
knowing how many there are left so i can't give page
numbers as:
<< first 2 3 4 last >>. perhaps running the query
twice, first time wihtout limit to see how many there
were and the 2nd just for a particular bunch with
limit. wouldn't that load the mysql db? and what if
i've got 10,000 rows or so? the query will take time.
any solutions?

thanks
abs

________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]