pagination

[Lone_Ranger]

How would I create a pagination from the following code I got for looking up a database.

 

 

$select_gamereview = mysql_query("select * from news where category='gamereview' order by topic ASC");
while($news = mysql_fetch_array($select_gamereview))
{
$position=780;
 $message="$news[article]";
 $post = substr($message, 0, $position);
 
echo "$news[topic]";
echo "$post ...";

 

how can I update this in order for it to show the first 15 results on page one and page 2 has the next 15 results and so on......

[fastsol]

Check out this tutorial series http://www.youtube.com/playlist?list=PL1A88F9FF46F82198

[Barrikor]

Just change:

 

"select * from news where category='gamereview' order by topic ASC"

 

 

To:

 

"select * from news where category='gamereview' order by topic ASC LIMIT $limit OFFSET $offest"

 

 

Where $limit and $offset are set by:

$current_page_number = 1; // for example 
$limit = 15;
$offset = $limit * ($current_page_number - 1);

Edited September 6, 2013 by Barrikor

[Lone_Ranger]

figured it this is how I have done it in case anyone browsing wants to use the code

 

 

$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$pages = implode(mysql_fetch_assoc(mysql_query("SELECT COUNT(id) FROM news")));
$pages = ceil($pages / 10);
$querystring = "";
foreach ($_GET as $key => $value) {
 if ($key != "page") $querystring .= "$key=$value&";
}
echo "Pages: ";
for ($i = 1; $i <= $pages; $i++) {
 echo "<a " . ($i == $page ? "class=\"selected\" " : "");
 echo "href=\"?{$querystring}page=$i";
 echo "\">$i</a> ";
}
$result = mysql_query("SELECT * FROM news where category='gamereview' order by topic ASC LIMIT " . (($page - 1) * 10) . ", 10");
while($news = mysql_fetch_array($result))
{
$position=780;
 $message="$news[article]";
 $post = substr($message, 0, $position);
 
echo "$news[topic]"; 
echo "$post ...";
}