Hi use a LIMIT clause in your SQL. Something like: $query="SELECT * FROM xxxx WHERE hello = '$hello' LIMIT " . ($page - 1) * $rows . ", $rows"; then you only need specify the logic to set the page, row and limitations Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
