$maxRows_@@RecordsetName@@ = @@PageSize@@;
$pageNum_@@RecordsetName@@ = @@StartRecord@@;
if (isset($_GET['pageNum_@@RecordsetName@@'])) {
$pageNum_@@RecordsetName@@ = $_GET['pageNum_@@RecordsetName@@'];
}
$startRow_@@RecordsetName@@ = $pageNum_@@RecordsetName@@ * $maxRows_@@RecordsetName@@;
<@ endif @>
<@ loop (@@Variable@@, @@DefaultValue@@, @@RuntimeValue@@) @>
$@@Variable@@_@@RecordsetName@@ = "@@DefaultValue@@";
if (isset(@@RuntimeValue@@)) {
$@@Variable@@_@@RecordsetName@@ = (get_magic_quotes_gpc()) ? @@RuntimeValue@@ : addslashes(@@RuntimeValue@@);
}
<@ endloop @>
mysql_select_db($database_@@ConnectionName@@, $@@ConnectionName@@);
$recordID = $_GET['recordID'];
$query_@@RecordsetName@@ = <@ if (@@SQLVariableList@@) @>sprintf(<@ endif @>"@@SQLStatement@@"<@ if (@@SQLVariableList@@) @>, @@SQLVariableList@@)<@ endif @>;
<@ if (@@PageSize@@) @>
$query_limit_@@RecordsetName@@ = sprintf("%s LIMIT %d, %d", $query_@@RecordsetName@@, $startRow_@@RecordsetName@@, $maxRows_@@RecordsetName@@);
$@@RecordsetName@@ = mysql_query($query_limit_@@RecordsetName@@, $@@ConnectionName@@) or die(mysql_error());
<@ else @>
$@@RecordsetName@@ = mysql_query($query_@@RecordsetName@@, $@@ConnectionName@@) or die(mysql_error());
<@ endif @>
$row_@@RecordsetName@@ = mysql_fetch_assoc($@@RecordsetName@@);
<@ if (@@PageSize@@) @>
if (isset($_GET['totalRows_@@RecordsetName@@'])) {
$totalRows_@@RecordsetName@@ = $_GET['totalRows_@@RecordsetName@@'];
} else {
$all_@@RecordsetName@@ = mysql_query($query_@@RecordsetName@@);
$totalRows_@@RecordsetName@@ = mysql_num_rows($all_@@RecordsetName@@);
}
$totalPages_@@RecordsetName@@ = ceil($totalRows_@@RecordsetName@@/$maxRows_@@RecordsetName@@)-1;
<@ else @>
$totalRows_@@RecordsetName@@ = mysql_num_rows($@@RecordsetName@@);
<@ endif @>
?>]]>
)/i]]>
mysql_select_db($database_