posted April 30, 2000 12:41 PM            

$numresults=mysql_query("SELECT * FROM arzt WHERE fach1 = 'strahle' ORDER BY nachname");
$numrows=mysql_num_rows($numresults);

// next determine if offset has been passed to script, if not use 0
if (empty($offset))
{
$offset=0;
}
// get results (assuming a limit of 20, use whatever you need)
$results=mysql_query("select * from arzt WHERE fach1 = 'strahle' ORDER BY nachname limit $offset,10");

// now you can display the 20 results returned
$i=1;
while ($data=mysql_fetch_array($results))
{
print "$i Name: $data[nachname]<br>\n";
$i++;
}

// next we need to do the links to other results
if (!$offset) // bypass PREV link if offset is 0
{
$prevoffset=$offset-20;
print "<a href='$PHP_SELF?offset=$newoffset>PREV</a> \n";
}

// calculate number of pages needing links
$pages=intval($numrows/20);
// $pages now contains int of pages needed unless there is a remainder from division
if ($numrows%20)
{

// has remainder so add one page
$pages++;
}
for ($i=1;$i<=$pages;$i++) // loop thru
{
$newoffset=20*$i;
print "<a href='/old?u=http%3A%2F%2Fwww.devshed.com%2FTalk%2FForums%2FForum5%2FHTML%2F%24PHP_SELF%3Foffset%3D%24newoffset&y=1999'>$i</a> \n";
}

// check to see if last page
if (!(($offset/20)==$pages))
{
// not last page so give NEXT link
$newoffset=$offset+20;
print "<a href='/old?u=http%3A%2F%2Fwww.devshed.com%2FTalk%2FForums%2FForum5%2FHTML%2F%24PHP_SELF%3Foffset%3D%24newoffset&y=1999'>NEXT</a><p>\n";
}
?>

when a category have less than 10 entries the script generates a prev button. that's very shi...... Have anybody from you a better method. If so , please message me.