Hi, how to query a list of records limiting the score, but including the
TOTAL of records satisfying the condition, all in one statement?
i.e.
SELECT title FROM news WHERE cond1 LIMIT 1, 10
plus
SELECT count(*) from NEWS WHERE cond1
all in one.
Thanks in advance
Nico
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
