[tommyc325]

So i`m trying to create one of those page navigation ( Next Last Page 1,2,3,4,5,6,7) i`m recieving "You have an error in your SQL syntax near '0, 10' at line 1" error message.

and below is the code don`t understand whats up.

PLEASE HELP

PHP Code:

$currentPage = $_SERVER["PHP_SELF"];



$maxRows_news = 10;

$pageNum_news = 0;

if (isset($_GET['pageNum_news'])) {

  $pageNum_news = $_GET['pageNum_news'];

}

$startRow_news = $pageNum_news * $maxRows_news;



// 03-10-01 

$today2 = date('Ymd');

$spitrecords = '999999999999999999999';



mysql_select_db($database_oconn, $oconn);

$query_news = "SELECT id, headline, content, date_format(date, '%c-%d-%y') as 'date_f' FROM news WHERE date <= $today2 ORDER by date DESC LIMIT 10, $spitrecords";

$query_limit_news = sprintf("%s LIMIT %d, %d", $query_news, $startRow_news, $maxRows_news);

$news = mysql_query($query_limit_news, $oconn) or die(mysql_error());

$row_news = mysql_fetch_assoc($news);



if (isset($_GET['totalRows_news'])) {

  $totalRows_news = $_GET['totalRows_news'];

} else {

  $all_news = mysql_query($query_news);

  $totalRows_news = mysql_num_rows($all_news);

}

$totalPages_news = ceil($totalRows_news/$maxRows_news)-1;



$queryString_news = "";

if (!empty($_SERVER['QUERY_STRING'])) {

  $params = explode("&", $_SERVER['QUERY_STRING']);

  $newParams = array();

  foreach ($params as $param) {

    if (stristr($param, "pageNum_news") == false && 

        stristr($param, "totalRows_news") == false) {

      array_push($newParams, $param);

    }

  }

  if (count($newParams) != 0) {

    $queryString_news = "&" . htmlentities(implode("&", $newParams));

  }

}

$queryString_news = sprintf("&totalRows_news=%d%s", $totalRows_news, $queryString_news); 

[dennispopel]

Hello

$query_news = "SELECT id, headline, content, date_format(date, '%c-%d-%y') as 'date_f' FROM news WHERE date <= $today2 ORDER by date DESC ";
$query_limit_news = sprintf("%s LIMIT %d, %d", $query_news, $startRow_news, $maxRows_news);

since you duplicate the LIMIT clause

[tommyc325]

Thanks but i need that limit tag in my query.