/    Sign up×
Community /Pin to ProfileBookmark

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?
[B]PHP[/B]

[code=php]
// 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;
[/code]

[B]HTML[/B]

[code=html]<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>[/code]

to post a comment
PHP

3 Comments(s)

Copy linkTweet thisAlerts:
@NogDogJun 10.2013 — I'm guessing what you really want to to increase the OFFSET by one, but keep the LIMIT at a fixed value?
Copy linkTweet thisAlerts:
@didsunauthorJun 10.2013 — I'm guessing what you really want to to increase the OFFSET by one, but keep the LIMIT at a fixed value?[/QUOTE]

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 &#8203;&#8203;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
Copy linkTweet thisAlerts:
@NogDogJun 10.2013 — Oops, I see you are, in fact, using $idup as an offset -- I typically use the [FONT=Courier New][B]LIMIT x OFFSET y[/B][/FONT] syntax, so I don't have to remember which comes first when you use the [B][FONT=Courier New]LIMIT x, y[/FONT][/B] syntax. ?

At a quick scan, I think this might do the trick, but is, of course:
[code=php]
<?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>";
?>
[/code]
×

Success!

Help @didsun spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 6.2,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,
)...