display all content containing specials

i have a section specials under it there will be added more when i hit add more content
is it possible to display them all with 5 at a time

When you add the repeat region to show the recordset, set it to show 5 records, then add recordset paging.

for instance record set
SELECT DISTINCT ContentGroup
FROM pcms2_contents
ORDER BY ContentGroup
how do i fiter only special no url plain php page
for instance specials.php

not enough information.

how is a record defined as a special?

in the left hand side admin there is a special sec
in the load content section there will be more content

SELECT DISTINCT ContentGroup
FROM pcms2_contents
WHERE ContentGroup = "specials"
ORDER BY ContentGroup

Your using a Power CMS Template right? See this tutorial:
http://www.webassist.com/tutorials/Use-templates-in-PowerCMS