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 To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
