#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 1999
    Location
    Berlin/germany
    Posts
    3
    Rep 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
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    Change the
    if (!$offset)
    to
    if ($offset)

Similar Threads

  1. Replies: 11
    Last Post: February 21st, 2004, 06:48 AM
  2. Unknown problem with login page
    By foxache in forum PHP Development
    Replies: 2
    Last Post: February 18th, 2004, 03:20 AM
  3. Replies: 0
    Last Post: February 8th, 2004, 10:11 PM
  4. Replies: 2
    Last Post: February 4th, 2004, 11:10 PM
  5. Major session problem suddenly occured!
    By njcallen in forum PHP Development
    Replies: 7
    Last Post: February 3rd, 2004, 07:31 PM

IMN logo majestic logo threadwatch logo seochat tools logo