prev...next links with odbc

[Anon]

How do i make prev...next links from an odbc query?

[Anon]

Hey howard,
Well if you are trying to do previous and next links ... why don't you make the links another php3 file ...

using the include or require functions ...

or set flags .. and use either a switch(case statement) or a bunch of if statements.

Hope that helps ..

Raistlen ...

[skmalla]

$limit = 20;
if (!$offset)
{
$offset = 0;
}
function pagenav()
{
global $limit,$offset,$numpage,$where;
if ($where)
{
$safewhere=urlencode($where);
}
echo "<TABLE CELLPADDING=0 BORDER=0 CELLSPACING=5 WIDTH=100% align=\"center\"><tr>&nbsp;&nbsp;</tr><TR align=center><TD ALIGN='center'>";
if ($offset>=$limit)
{
$newoff=$offset-$limit;

        echo "<A HREF=\"$PHP_SELF?offset=$newoff\">Prev</A>";
    }
	else 
	{
        echo "PREV";
    }
    echo "<font size=2><b>&nbsp;&nbsp;</b></font> ";
    for ($i=1;$i<=$numpage;$i++) 
	{
        if ((($i-1)*$limit)==$offset) 
		{
            print "$i ";
        }
		else 
		{
            $newoff=($i-1)*$limit;
            echo "<A HREF=\"$PHP_SELF?offset=$newoff\">
					$i</A>";
        }
    }
    echo "&nbsp;";
if ($offset!=$limit*($numpage-1) && $offset=="NULL") 
{
	$newoff=$offset+$limit;
    echo "<A HREF=\"$PHP_SELF?offset=$newoff\">next</A></TD>";
}
else
{
	echo "NEXT";
}
 echo "</TR></TABLE>";

} // END FUNCTION

Use the above function to extract the results. remember to put $limit value in select SQL statement along with offset

Have a great coding...