MX Looper Forum :: How can I to limit recordset in SQL string and apply Page Na

Hello,

How can I to limit recordset in SQL string and apply Page Naviagation Bar behavior at the same time? It will show the message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LMIT 1 LIMIT 0, 10' at line 1

---

$maxRows_rsSmsSmseLogSendListing = 10;
$pageNum_rsSmsSmseLogSendListing = 0;
if (isset($_GET['pageNum_rsSmsSmseLogSendListing'])) {
  $pageNum_rsSmsSmseLogSendListing = $_GET['pageNum_rsSmsSmseLogSendListing'];
}
$startRow_rsSmsSmseLogSendListing = $pageNum_rsSmsSmseLogSendListing * $maxRows_rsSmsSmseLogSendListing;

$colname_rsSmsSmseLogSendListing = "-1";
if (isset($_SESSION['kt_login_id'])) {
  $colname_rsSmsSmseLogSendListing = (get_magic_quotes_gpc()) ? $_SESSION['kt_login_id'] : addslashes($_SESSION['kt_login_id']);
}
mysql_select_db($database_connSms, $connSms);
$query_rsSmsSmseLogSendListing = sprintf("SELECT * FROM sms_smse_log_send WHERE sms_acct_id = %s ORDER BY create_date DESC LMIT 1", GetSQLValueString($colname_rsSmsSmseLogSendListing, "text"));
$query_limit_rsSmsSmseLogSendListing = sprintf("%s LIMIT %d, %d", $query_rsSmsSmseLogSendListing, $startRow_rsSmsSmseLogSendListing, $maxRows_rsSmsSmseLogSendListing);
$rsSmsSmseLogSendListing = mysql_query($query_limit_rsSmsSmseLogSendListing, $connSms) or die(mysql_error());
$row_rsSmsSmseLogSendListing = mysql_fetch_assoc($rsSmsSmseLogSendListing);

Thank you.

Hello,

If I understand correctly, you want to limit the records displayed on a page. If this is the case, then you must not add a LIMIT clause as another one will be added by the navigation code. You can simply modify the value of the variable 

$maxRows_rsSmsSmseLogSendListing

Regards,
Razvan RACASANU