$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)
{