$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@@); $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_