Posted by lists.niekas on 05/03/06 10:53
For limiting the returned results by a query try using the LIMIT (
"SELECT .. FROM .. LIMIT 10,10" - will return 10 rows from the query
starting from 10th row).
In order to have total count of rows you will have to use separate
query like: "SELECT COUNT(*) AS count FROM ... WHERE ..."
--
Niekas [ more mySQL help at http://forums.niekas.com ]
[Back to original message]
|