www.webdeveloper.com
Results 1 to 4 of 4

Thread: How to increase LIMIT by one when I click Next

Hybrid View

  1. #1
    Join Date
    Jun 2013
    Posts
    2

    How to increase LIMIT by one when I click Next

    Hello everyone, recently studying PHP and have a serious problem. Here is my case - I have a database in which I have ID, Fullname, and County and Online. As I pressed the button "Next" to transfer to the next member in alphabetical order. But I can not do so in LIMIT can not increase the value of LIMIT by one.
    Or do you have any other ideas?
    PHP
    PHP Code:
    // Get Info
    $result mysql_query("SELECT * FROM users WHERE id='$id'");
    $row mysql_fetch_array($result);
    $id $_GET['id'];

    // Get next link to user by fullname 
    $queryup mysql_query("select * from users order by fullname LIMIT "$idup" ,1");
    $rowidup mysql_fetch_array($queryup);
    $nxt $rowidup['id'];
    echo 
    $nxt
    HTML
    HTML Code:
    <form method="post" action="" onSubmit="window.location.reload()">
    <table border="1" width="100%">
    <tr>
    <td>Full name</td>
    <td><input type="text" name="fullname" value="<?php echo $row['fullname']; ?>" /></td>
    </tr>
    <tr>
    <td>E-mail</td>
    <td><input type="text" name="email" value="<?php echo $row['email']; ?>" /></td>
    </tr>
    <tr>
    <td>Country</td>
    <td>
    <?php echo "$row['country']; ?>
    </td>
    </tr>
    <tr>
    <td>Online</td>
    <td>
    <?php
    	if ($row['onlinecheck'] == '1') {
    	echo "<input type='checkbox' name='onlinecheck' checked value='0' />";
    	} else {
    	echo "<input type='checkbox' name='onlinecheck' value='1' />";
    	}
    ?>
    </td>
    </tr>
    </table>
    
    <input type="submit" name="submit" class="navbtn" value="Save" />
    <?php echo "<a href='index.php?id=$nxt' class='navbtn'>Next </a>"; ?>
    </form>

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,535
    I'm guessing what you really want to to increase the OFFSET by one, but keep the LIMIT at a fixed value?
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  3. #3
    Join Date
    Jun 2013
    Posts
    2
    Quote Originally Posted by NogDog View Post
    I'm guessing what you really want to to increase the OFFSET by one, but keep the LIMIT at a fixed value?
    I like when I hit "Next" to increase the value of $ idup be increased by one to be able to show me the next user. If you have an idea of ​​how otherwise can be done will be glad to share it, I would be very grateful if someone help me so in the last 3 days more than 10 hours I've been trying to do it and I can not.
    Regards

  4. #4
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,535
    Oops, I see you are, in fact, using $idup as an offset -- I typically use the LIMIT x OFFSET y syntax, so I don't have to remember which comes first when you use the LIMIT x, y syntax.

    At a quick scan, I think this might do the trick, but is, of course:
    PHP Code:
    <?php 
    if(!empty($_GET['nxt'])) {
        
    $nxt $_GET['nxt'] + 1;
    }
    else {
        
    $nxt 1// assume we're on the very first result (offset 0)
    }
    echo 
    "<a href='index.php?id=$nxt' class='navbtn'>Next </a>"
    ?>
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles