I know that while() works either whether condition is true or isn't null. I just can't figure on how, I think I could use loop around that, but then you would need 2 scripts which one after another reload the query. This is hard way, which I may know how to do after day or two, but to my expectation there should be mucho moro efficient way.
I think we misunderstood one another. @diafol you created correct script, to missing situation. I'm willing to get "while" to displaying results in pairs, not one by one. What while does is getting results id=1, id=2, id=3, id=4. But what I'm actually seeking is id=1 and id=2, id=3 and id=4, id=5 and id=6.
I tried to manage that loop, but I messed up my entire website, it doesn't even display anymore... poor me.
@edit - Wait. That actually might be adjustable to work just right.
Just don't create spin-offs please. I wish to keep my code little bit private. I'm not feared for someone to use it, I don't want my teacher to able to find this chunk of source code and bind it with my username. Internet is internet, life is life.
BTW, please post code here - going to pastebin etc is a pain.
Sorry I can't. You can't delete code from here, but it expires itself from Pastebin.
Go to PDO or mysqli.
You'd be suprised, noobs like me, only support mysql since that's only one I can install. Assumably mysqli is "newer" improved version of mysql and assumeable I'd need to learn new commands. I barely got mysql working don't ask me to get mysqli to work.
Why do you need the code to expire? It's not as if it's anything new - this type of code has been posted on daniweb hundreds of times and thousands of times over all the other forums. As Daniweb is a learning resource, we expect visitors to look at our threads and be able to resolve their issues. If you post "vanishing code", you deprive others of this ability and leave threads in a state of disarray.
Mysqli is not "installed" like mysql. It's a part of PHP. mysqli and PDO were introduced in version 5.0 (July 2004). I'm assuming that you're not running PHP4. So you can use mysqli or PDO.
But, up to you. Running obsolete code has its dangers. In addition you are not developing your skills for 2014 and the future.
PHP Version 5.5.9-1ubuntu4.3, I think it's version 5.5.
As Daniweb is a learning resource, we expect visitors to look at our threads and be able to resolve their issues.
Gah, "I don't like this game, but I know how to beat it". The struggle is not about solving a problem within a script, it's about finding proper script to get it to work. HTML + CSS work just fine, just when you ask database and try to automize the process, PHP file turns out to be troll.