I have table with 100 records +------------+--------------------------+------+-----+---------+---------------- | Field | Type | Null | Key | Default | Extra | +------------+--------------------------+------+-----+---------+---------------- | decID | int(11) | | PRI | 0 |auto_increment | | userID | int(11) | YES | | NULL | | exp_data | date | YES | | NULL | | text_field | varchar(150) | YES | | NULL | | type | enum('to rent','to buy') | | | to rent | +------------+--------------------------+------+-----+---------+---------------- where decId from 1..1000 how get five records from 25 from table where key may be different value from [1..1000] sorry for my bad English. --------------------------------------------------------------------- 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