I hate to raz but this subject has been beeten to death, haha.
check out the LIMIT command
http://mysql.com/doc/S/E/SELECT.html
also check out articles on this very site.
http://phpbuilder.com/columns/rod20000221.php3
have fun, its not hard, you'll take one look and know what your doing 🙂
Chris Lee
lee@mediawaveonline.com