How to implement next prev to my blog

Posted by lena on Stack Overflow See other posts from Stack Overflow or by lena
Published on 2010-04-11T15:50:11Z Indexed on 2010/04/11 15:53 UTC
Read the original article Hit count: 331

Filed under:
|
|
|

Hi,

I have created a basic PHP blog-cms and I'm looking for a easy way to implement prev next. on the blog page.

I know there are several Jquery plugins, also some people use PHP to achieve this... I'm looking for the more simple and easy way to do it.

I want to display 2 news by page

The code:

<?php

  $q = 'SELECT news.user_id,news.date,news.title,news.intro,news.content,news.status,news.visible, CONCAT(users.firstname," ", users.name) AS uname FROM news LEFT JOIN users ON users.id = news.user_id WHERE news.status= 1 AND news.visible=1 AND news.language=1 ORDER BY news.date DESC';
  $res = sqlq($q);
while ($r = sqlget($res)) { 

  echo 
  '<div> <h5> '  .  $r['title'] . '</h5> </div>' . 
  '<div>' . $r['date'] . ' | ' . $r['uname'] .'</div>' .
  '</br>'.
  '</br>'.
 '<p>'.
  '<div>' . $r['intro'] . '</div>' .
  '</p>'.
  '</br>'.
  '<p>'.
  '<div>' . $r['content'] . '</div>'.    
  '</p>'.
  '<hr>' ;
} //while

?>

Thanks for your help

© Stack Overflow or respective owner

Related posts about php

Related posts about jQuery