PHP SQL Next Row and previous Fetch

[ajs1351]

hello, im trying to do some php , and sql, to grab the next or previous record when pressed one of the buttons, and display on page. the thing is that will display the next row from the db, but then it wont execute again, when i click on next , it just sits there. i dont know if i need a loop, but i cant figure what missing.

 <form method="POST" action="Controller_leads.php">
        <p><strong>What kind of comment would you like to send?</strong></p>
        <input type="radio" <?php if ($MessageType == "Complaint")   echo "checked"; ?> name="MessageType" value="Complaint">Complaint 
        <input type="radio" <?php if ($MessageType == "Problem")   echo "checked"; ?>  name="MessageType" value="Problem">Problem
        <input type="radio" <?php if ($MessageType == "Suggestion")   echo "checked"; ?>  name="MessageType" value="Suggestion">Suggestion
        <br> 
        <p><strong>What about us do you want to comment on?</strong></p>

        <select name="Drop_Down" size="1">
            <option value ="Web Site" <?php if ($Drop_Down == "Web Site") echo selected ?>>Web Site</option>
            <option value ="Office Hours" <?php if ($Drop_Down == "Office hours") echo selected ?>>Office Hours</option>
            <option value ="Pamphlet" <?php if ($Drop_Down == "Pamphlet") echo selected ?>>Pamphlet</option>
        </select>

        Other: <input type="text" size="26" maxlength="256" name="SubjectOther" value="<?php echo $SubjectOther ?>">

        <p><strong>Enter your comments in the space provided below:</strong></p>

        <textarea name="Comments" rows="5" cols="42"><?php echo $Comments;?></textarea><br><br>

        <strong>Tell us how to get in touch with you:</strong><br><br>

        <table>
          <tr><td width="45">&nbsp;Name     </td> <td><input type="text" size="35" maxlength="256" name="UserName" value="<?php echo $Name_Field ?> "></td></tr>
          <tr><td width="45">&nbsp;E-mail   </td> <td><input type="text" size="35" maxlength="256" name="UserEmail" value="<?php echo $Email_Field ?>"></td></tr>
          <tr><td width="45">&nbsp;Telephone</td> <td><input type="text" size="35" maxlength="256" name="UserTel" value="<?php echo $UserTel ?>"></td></tr>
        </table>

        <br>
        <input type="checkbox" name="Check" <?php if ($Check == "Contact Requested") echo checked; ?> value="Contact Requested">Please contact me as soon as possible regarding this matter
        <br><br> 
        <input type="submit" value="First" name="first"> 
        <input type="submit" value="Next" name="next"> 
        <input type="submit" value="Previous" name="previous"> 
        <input type="submit" value="Last" name="last"> 
        <input type="hidden" name="offset"  value="<?php echo $offset ?>" > 
        <br>
    </form>

    php code.

       <?php

            $Email_Field   = $_POST['UserEmail']; 
            $Name_Field    = $_POST['UserName']; 
            $UserTel       = $_POST['UserTel'];   
            $Drop_Down     = $_POST['Drop_Down'];
            $MessageType   = $_POST['MessageType'];
            $Comments       = $_POST['Comments'];
            $SubjectOther  = $_POST['SubjectOther'];
            $Check         = $_POST['Check'];

        $offset = 1;

    # if we have an offset from a previous or next click, use that
    if (isset($_POST['offset'])) {

    # validate this input to protect against sql injection
    if (is_int($_POST['offset'])) {
        $offset = $_POST['offset'];
    }

    # now that we have our current value, see if we need to get the next or previous
    if ($_POST['submit']=="Next") {
        # next, add one offset
        $offset++;
    } else if ($_POST['submit']=="Previous") {
        # previous, go back one if we are greater than one
        if ($offset > 1) {
            $offset--;
        }
    }
}



     //$sql="SELECT * FROM Emails where ID > 0 ORDER BY ID LIMIT 1, $offset";
     $sql = "SELECT * FROM Emails where ID > 0
        ORDER BY ID LIMIT 1, $offset";

         if ($result=mysqli_query($connection,$sql))
          {

          // Return the number of rows in result set
          $rowcount=mysqli_num_rows($result);

          while( $row = mysqli_fetch_array( $result ) )
          {
             $Email_Field         = $row['UserEmail'];        
             $Name_Field          = $row['UserName'];           
             $UserTel             = $row['UserTel'];         
             $Drop_Down           = $row['Drop_down'];      
             $MessageType         = $row['MessageType'];       
             $Comments            = $row['Comments'];        
             $SubjectOther        = $row['SubjectOther'];        
             $Check               = $row['Request'];         
          }