PHP-MySql: Select previous row and next row from current ID Posted on July 15, 2008July 15, 2008 by Miaz AkemapaIn Programming mysqlphpprogramming
for anchor tag, what code code i used to disable the already exist anchor in php when all record empty in database Reply
Hi, I’m kind of new with the SQL queries and your post really helped me. It was exactly what I was looking for. Thanks, Omar Reply
I’ve been looking for a clean and simple solution to do this and you’ve shown that simplicity can get it done! Nice work, Cheers! Reply
And what if we reach end of records and want to start over from first, and viceversa if moving to previous? (i.e looping over) Reply
Very simple, I can’t believe I was stumped for so long on this. Very logical explanation. Thanks! Reply
Hi, how can i perform this operation on 3 columns in php ? Sr A B C 1 200 100 1000 2 300 0 700 C2 = C1 – (A2 + B2) ——- Thanks Reply
Perfect IDEA, thanks a loot, saya sangat pusing mikirin gimana caranya, gatau nya simple sekali, terimakasih banyak, Salam dari Indonesia Reply
for anchor tag, what code code i used to disable the already exist anchor in php when all record empty in database
Hi,
I’m kind of new with the SQL queries and your post really helped me. It was exactly what I was looking for.
Thanks,
Omar
I’ve been looking for a clean and simple solution to do this and you’ve shown that simplicity can get it done!
Nice work, Cheers!
And what if we reach end of records and want to start over from first, and viceversa if moving to previous? (i.e looping over)
I want to ask one, how do I retrieve the current value of ID in PHP, Tks
Very simple, I can’t believe I was stumped for so long on this. Very logical explanation.
Thanks!
Hi,
how can i perform this operation on 3 columns in php ?
Sr A B C
1 200 100 1000
2 300 0 700
C2 = C1 – (A2 + B2)
——-
Thanks
what if the last number of row? like 1-34 ? 35 cannot find the id…
I LOVE U… You idea very amazing…
good, finally one clean solution 😀
good
Perfect IDEA, thanks a loot, saya sangat pusing mikirin gimana caranya, gatau nya simple sekali, terimakasih banyak, Salam dari Indonesia