journal previous next links

[Dillenger]

Hi,

I'm pulling data from my database to create a journal. I'm wondering how I can add previous next links into my script so that each entry displays seperately.

Here is my code:

<?PHP
require('config.inc');
// connect to database
$cid = mysql_connect($host,$usr,$passwd);
$select_db = mysql_select_db($db); 

$sql = "SELECT id, title, entry, date FROM news";

$result = mysql_query($sql); 

while ($directory = mysql_fetch_array($result)) { 

  $id = $directory['id']; 
  $title  = $directory['title'];
  $entry = $directory['entry'];
  $date = $directory['date'];

  echo "$date<br><br>";
  echo "<b>$title</b><br><br>";
  echo "$entry<br><br><br>";

}
?>

[Weedpacket]

There are a couple of articles on this site that cover exactly this topic; there's also any number of threads on this forum doing the same thing.

[greg252]

Look at ORDER BY to get the data in a logical progression.
Look at LIMIT (2 args) to get next and prev records.
There's a lot of stuff about this.