How to arrange a mySQL database with PHP?

[PugJr]

Like for instance I have 3 rows like this:

 

ID var

3  6

4  8

5  3

 

How would I select the third row and put it as the first one, then making the first row become second, and second become third or some mysql order through PHP that can just move a row from one place to another.

 

Thanks.

[Kieran Menor]

Isn't this just a matter of doing something like:

 

SELECT * FROM `table` ORDER BY `var`

[Maq]

How would I select the third row and put it as the first one, then making the first row become second, and second become third or some mysql order through PHP that can just move a row from one place to another.

 

Are you referring to actually ALTERing the MySQL table?  Which is a bad idea, and most likely due to poor design.  Or display it in the order you described, which I like to call, reverse, or DESCending.

[PugJr]

Yeah...I was referring to actually altering the table, but what you mention would work as well. How would you do that reverse or descending when reading a table or whatever it does. Thank you!

[Maq]

If you just want to display the table in descending order by id do something like:

 

 

SELECT * FROM table ORDER BY id DESC