hi, i am working with the Dreamweaver Repeat region. I want to pull 100 record
from a query and then view them 10 at the time (10 per page).

the code below, does the 10 records per page, but loads the entire recordset
from the tables (1000s of records).

how can I limit the query so that you end up navigating only 100 records?

many thanks,

Federico

************************************************

$maxRows_master1contacts = 10;
$pageNum_master1contacts = 0;
if (isset($_GET['pageNum_master1contacts'])) {
$pageNum_master1contacts = $_GET['pageNum_master1contacts'];
}
$startRow_master1contacts = $pageNum_master1contacts *
$maxRows_master1contacts;

mysql_select_db($database_themis, $themis);
$query_master1contacts = "Select concat_ws('
',contacts.contact_title,contacts.contact_first_na me,contacts.contact_middle_nam
e,contacts.contact_last_name) AS contact_name,contacts.contact_id,
contacts.date_updated, contacts.user_updated, contacts.user_created,
contacts.date_created, oemp_members.MemberID,
Count(oemp_maillist_members.RelMailListID) AS subscriptions,
contacts.contact_last_name FROM contacts Left Join oemp_members ON
contacts.contact_id = oemp_members.MemberID Left Join oemp_maillist_members ON
oemp_members.MemberID = oemp_maillist_members.RelMemberID GROUP BY
contacts.contact_id Order By contacts.date_created Desc";

$query_limit_master1contacts = sprintf("%s LIMIT %d, %d",
$query_master1contacts, $startRow_master1contacts, $maxRows_master1contacts);
$master1contacts = mysql_query($query_limit_master1contacts, $themis) or
die(mysql_error());
$row_master1contacts = mysql_fetch_assoc($master1contacts);

************************************************** ******