The main part of code i m using for Forward and Backward is,
if($page > 1)
{
$prev = ($page - 1);
echo "<a
href=\"".$_SERVER['PHP_SELF']."?page=$prev&&searchfor=$searchfor&&seek=$seek&&age1=$age1&&age2=$age2&&state=$state&&country=$country\"
TARGET=\"_parent\"><<Previous</a> ";
}
for($i = 1; $i <= $total_pages; $i++)
{
if(($page) == $i)
{
echo "$i ";
} else
{
echo "<a
href=\"".$_SERVER['PHP_SELF']."?page=$i&&searchfor=$searchfor&&seek=$seek&&age1=$age1&&age2=$age2&&state=$state&&country=$country\"
TARGET=\"_parent\">$i</a> ";
}
}
// Build Next Link
if($page < $total_pages)
{
$next = ($page + 1);
echo "<a
href=\"".$_SERVER['PHP_SELF']."?page=$next&&searchfor=$searchfor&&seek=$seek&&age1=$age1&&age2=$age2&&state=$state&&country=$country\"
TARGET=\"_parent\">Next>></a>";
}
Change variables accroding to u.
John Taylor-Johnston <[EMAIL PROTECTED]> wrote:
Finally something I can give back, made by my little lonesome with no help :)
> I have a query that returns lots of rows so I want to display the results in blocks
> of 25 or so on my web page and have forward and back buttons to navigate the results.
include it first:
include("settings_limit.inc");
then set $offset and $limit in your sql
$sql = 'SELECT *,MATCH (field1,field2)
AGAINST (\''.$searchenquiry.'\' IN BOOLEAN MODE)
AS relevancy FROM '.$table.'
WHERE MATCH (field1,field2)
AGAINST (\''.$searchenquiry.'\' IN BOOLEAN MODE)
ORDER BY relevancy DESC
LIMIT '.$offset.','.$limit.';';
------settings_limit.inc--------
#####################################################
## $mycounter is set by script calling settings_limit.inc ####
#####################################################
#####################################################
############### Set $offset & $limit ################
#####################################################
if((!$offset) || ($offset < 0))
{
$offset = 0;
}
$limit = 25;
#####################################################
############### $nextinsert #########################
#####################################################
$new_offset = $offset + $limit;
$disp = $limit;
if ($new_offset + $limit > $mycounter)
{
$disp = $mycounter - $new_offset;
}
if ($disp > 0)
{
$nextinsert = "Next ".$disp." Requests [input] >\"> [input] [input] [input] ";
if($searchenquiry)
$nextinsert .= " [input] ";
if($scholarsenquiry)
$nextinsert .= " [input] ";
if($titlesenquiry)
$nextinsert .= " [input] ";
$nextinsert .= "";
}
#####################################################
############### $previousinsert #####################
#####################################################
$new_offset2 = $offset - $limit;
if ($offset > 0) // can display previous msg
{
$disp = $limit;
$previousinsert = " << Previous ".$disp." Requests";
$previousinsert = " [input] Previous ".$disp." Requests [input] [input] [input] ";
if($searchenquiry)
$previousinsert .= " [input] ";
if($scholarsenquiry)
$previousinsert .= " [input] ";
if($titlesenquiry)
$previousinsert .= " [input] ";
$previousinsert .= "";
}
#####################################################
############### $lastinsert #########################
#####################################################
$new_offset3 = $mycounter - $limit;
if (($new_offset3 > $limit) and ($offset != $mycounter - $limit)) // can display goto
end msg
{
$lastinsert = "Go To End [input] >|\"> [input] [input] [input] ";
if($searchenquiry)
$lastinsert .= " [input] ";
if($scholarsenquiry)
$lastinsert .= " [input] ";
if($titlesenquiry)
$lastinsert .= " [input] ";
$lastinsert .= "";
}
#####################################################
############### $firstinsert ########################
#####################################################
$new_offset4 = $mycounter - $limit;
if ($new_offset4 > $limit) // can display goto beginning msg
{
$new_offset4 = 0;
$firstinsert = " [input] Go To Beginning [input] [input] [input] ";
if($searchenquiry)
$firstinsert .= " [input] ";
if($scholarsenquiry)
$firstinsert .= " [input] ";
if($titlesenquiry)
$firstinsert .= " [input] ";
$firstinsert .= "";
}
#####################################################
############### Display Inserts #####################
#####################################################
#####################################################
if (($previousinsert) or ($nextinsert))
#echo "";
echo "";
#if (($previousinsert) || ($nextinsert))
#echo "(Sorted by id - $mycounter records found total)";
if (($previousinsert) or ($nextinsert))
echo "";
if (($firstinsert) and ($offset != 0)) echo "$firstinsert";
if ($previousinsert) echo "$previousinsert";
if (($previousinsert) && ($nextinsert)) echo "| ";
if ($nextinsert) echo "$nextinsert";
if ($lastinsert) echo "$lastinsert";
if (($previousinsert) or ($nextinsert))
#echo "";
echo "";
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
