note 58719 deleted from control-structures.for by felipe
| From: | felipe@php.net | Date: | Tue, 29 Jan 2008 11:21:26 +0000 |
| Subject: | note 58719 deleted from control-structures.for by felipe | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-135516@lists.php.net to get a copy of this message | ||
Note Submitter:
----
if you wanted to make a next previous thing for mysql this would be it
$page = $_GET['page'];
// mysql query goes here
$limit = 30; //gets 30 of whatever
if(!$page){
$page = "1";
}
$limitvalue = $page * $limit - ($limit); //find the limit value
$query = mysql_query("SELECT * FROM
tableORDER BY id DESC LIMIT $limitvalue,
$limit");
$numrows = mysql_query("SELECT * FROM forum_topics WHERE forumid =
'$fid'");
$numofpages = ceil($numrows / $limit);
while ($r = mysql_fetch_array($query)){
// your stuff goes here
}
$pageprev = $page-1;
$pagenext = $page+1;
if ($page != "1"){
echo " <a href='linkhere.php?page=$pageprev'><< Previous</a>
";
}
for ($i = 1; $i <= $numofpages; $i++) {
if ($i == $page){
echo "<b>$i</b> ";
}
else {
echo "<a href='linkhere.php?page=$i'>$i</a> ";
}
}
if ($numrows > $limit){
if ($page != $numofpages){
echo " <a href='linkhere.php?page=$pagenext'>Next >></a> ";
}
}
There is also a few other ways but this is how i do it ^^