select next and previous record from database [on hold]











up vote
-1
down vote

favorite












have a nice time!
I am new to mysql and php, how can we query the previous and next row from database while the id is auto increment. would you mind helping me please! thanks in advance.






mysql







share|improve this question







New contributor




yusofi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as too broad by Scott, Pimp Juice IT, Toto, bertieb, fixer1234 2 days ago


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.











  • 1




    Have you tried anything? Do you have any small subset sample of data to provide?
    – Pimp Juice IT
    2 days ago










  • Previous and next from what? Do you have already a record selected? What you've tried?...
    – Máté Juhász
    2 days ago















up vote
-1
down vote

favorite












have a nice time!
I am new to mysql and php, how can we query the previous and next row from database while the id is auto increment. would you mind helping me please! thanks in advance.






mysql







share|improve this question







New contributor




yusofi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as too broad by Scott, Pimp Juice IT, Toto, bertieb, fixer1234 2 days ago


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.











  • 1




    Have you tried anything? Do you have any small subset sample of data to provide?
    – Pimp Juice IT
    2 days ago










  • Previous and next from what? Do you have already a record selected? What you've tried?...
    – Máté Juhász
    2 days ago













up vote
-1
down vote

favorite









up vote
-1
down vote

favorite











have a nice time!
I am new to mysql and php, how can we query the previous and next row from database while the id is auto increment. would you mind helping me please! thanks in advance.






mysql







share|improve this question







New contributor




yusofi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











have a nice time!
I am new to mysql and php, how can we query the previous and next row from database while the id is auto increment. would you mind helping me please! thanks in advance.






mysql




mysql






share|improve this question







New contributor




yusofi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question







New contributor




yusofi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question






New contributor




yusofi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 2 days ago









yusofi

1




1




New contributor




yusofi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





yusofi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






yusofi is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




put on hold as too broad by Scott, Pimp Juice IT, Toto, bertieb, fixer1234 2 days ago


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.






put on hold as too broad by Scott, Pimp Juice IT, Toto, bertieb, fixer1234 2 days ago


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.










  • 1




    Have you tried anything? Do you have any small subset sample of data to provide?
    – Pimp Juice IT
    2 days ago










  • Previous and next from what? Do you have already a record selected? What you've tried?...
    – Máté Juhász
    2 days ago














  • 1




    Have you tried anything? Do you have any small subset sample of data to provide?
    – Pimp Juice IT
    2 days ago










  • Previous and next from what? Do you have already a record selected? What you've tried?...
    – Máté Juhász
    2 days ago








1




1




Have you tried anything? Do you have any small subset sample of data to provide?
– Pimp Juice IT
2 days ago




Have you tried anything? Do you have any small subset sample of data to provide?
– Pimp Juice IT
2 days ago












Previous and next from what? Do you have already a record selected? What you've tried?...
– Máté Juhász
2 days ago




Previous and next from what? Do you have already a record selected? What you've tried?...
– Máté Juhász
2 days ago










1 Answer
1






active

oldest

votes

















up vote
-2
down vote













You need to iterate through all of the answers to your query in some sort of loop until you either get what you want or the results are exhausted. Here is an example from a previous question:



https://stackoverflow.com/questions/2285600/how-to-iterate-by-row-through-a-mysql-query-in-php






share|improve this answer




























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    -2
    down vote













    You need to iterate through all of the answers to your query in some sort of loop until you either get what you want or the results are exhausted. Here is an example from a previous question:



    https://stackoverflow.com/questions/2285600/how-to-iterate-by-row-through-a-mysql-query-in-php






    share|improve this answer

























      up vote
      -2
      down vote













      You need to iterate through all of the answers to your query in some sort of loop until you either get what you want or the results are exhausted. Here is an example from a previous question:



      https://stackoverflow.com/questions/2285600/how-to-iterate-by-row-through-a-mysql-query-in-php






      share|improve this answer























        up vote
        -2
        down vote










        up vote
        -2
        down vote









        You need to iterate through all of the answers to your query in some sort of loop until you either get what you want or the results are exhausted. Here is an example from a previous question:



        https://stackoverflow.com/questions/2285600/how-to-iterate-by-row-through-a-mysql-query-in-php






        share|improve this answer












        You need to iterate through all of the answers to your query in some sort of loop until you either get what you want or the results are exhausted. Here is an example from a previous question:



        https://stackoverflow.com/questions/2285600/how-to-iterate-by-row-through-a-mysql-query-in-php







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered 2 days ago









        grifferz

        58725




        58725















            -

            Popular posts from this blog

            flock() on closed filehandle LOCK_FILE at /usr/bin/apt-mirror

            Image
            0 I recently upgraded an Ubuntu 16.04 virtual machine to 18.04. I regularly use this VM to run apt-mirror at school on their high-speed internet, then rsync these files to my rack-mount server at home for updating multiple computers at home without wasting the tiny amount of bandwidth I have there. Since updating I can't get apt-mirror to run on my VM. It keeps giving the error: flock() on closed filehandle LOCK_FILE at /usr/bin/apt-mirror line 214 immediately followed by: apt-mirror is already running, exiting at /usr/bin/apt-mirror line 217 apt-mirror is NOT running, and does not have a cron job. I've tried rebooting, and even looked for the old-style lockfile to delete, but I guess that method is no longer used. Is there some way to force unlock this so I can run apt-mirror? UPDATE: So... I f...
            Read more

            Mangá

            Image
              Nota:  Não confundir com Manga. Mangás e Animes Mangá Mangaká • Tankōbon Film comic La nouvelle manga Mangá original em inglês Anime História Animação influenciada por animes • Filler • OVA • Seiyū Públicos Kodomo • Shōjo • Shōnen Josei • Seinen Gêneros Mahō shōjo • Mecha • Harém Ecchi • Hentai ( Yaoi • Yuri Futanari • Shotacon • Lolicon Toddlercon ) Termos Bishōjo • Chibi • Fan service Gaiden • Kawaii • Kaitō • Light novel Mahō shōnen • Moe (antropomorfismo • Kemonomimi Nekomimi ) • Super deformed Omake • Tsundere • Yonkoma Listas Mangás • Animes • Ecchi • Mangaka • Estúdios • Revistas Fãs ( otaku ) Anime Music Video Convenções • Cosplay Dōjinshi • Fansub • Fandub • Fujoshi OS-tan • Scanlation Portal de Anime e mangá v d e O mangá (português brasileiro) ou manga (português europeu) [ 1 ] (em japonês: 漫画 , manga ? , lit. “história em quadrinhos”) , é a ...
            Read more

            Eduardo VII do Reino Unido

            Image
            Eduardo VII Rei do Reino Unido da Grã-Bretanha e Irlanda e dos Domínios Britânicos de Além-mar Imperador da Índia Rei do Reino Unido e Imperador da Índia Reinado 22 de janeiro de 1901 a 6 de maio de 1910 Coroação 9 de agosto de 1902 Delhi Durbar 1 de janeiro de 1903 Predecessora Vitória Sucessor Jorge V   Esposa Alexandra da Dinamarca Descendência Alberto Vitor, Duque de Clarence e Avondale Jorge V do Reino Unido Luísa, Princesa Real Vitória de Gales Maud de Gales Alexandre João de Gales Casa Saxe-Coburgo-Gota Nome completo Alberto Eduardo Nascimento 9 de novembro de 1841   Palácio de Buckingham, Londres, Reino Unido Morte 6 de maio de 1910 (68 anos)   Palácio de Buckingham, Londres, Reino Unido Enterro Capela de São Jorge, Windsor, Berkshire, Reino Unido 20 de maio de 1910 Pai Alberto de Saxe-Coburgo-Gota Mãe Vitória do Reino Unido Assinatura ...
            Read more