
April 30th, 2000, 01:41 PM
|
|
Registered User
|
|
Join Date: Sep 1999
Location: Berlin/germany
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
here is the script:
<?;
include ("connect.php3");
$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='$PHP_SELF?offset=$newoffset'>$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='$PHP_SELF?offset=$newoffset'>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.
thanks, Ron
|