Sorting data elements and displaying with php

Question

I have a sql table 'sample' with 3 fields id,content, arrange. The field arrange gives the order to be displayed contents in html page.

 --------------------
 id|content|arrange
 --------------------
 1   A        4
 2   B        5
 3   C        1
 4   D        3
 5   E        2
-------------------

When use the query

SELECT content FROM sample order by arrange

gives me result in the order

 ----
 C
 E
 D
 A
 B
 ----

My question is how we can change the positions and update it in Database?

For example I need to move value 'A' to position of 'C', and all other contents should be relatively updated.

how can we do that?

SELECT content FROM sample order by arrange will arrange recordset . it will never gives result as you given. — alok.kumar
– alok.kumar, Commented Nov 30, 2013 at 6:26
I'm taking the values of table 'sample' to display content based on arrange field value. — Jojo George
– Jojo George, Commented Nov 30, 2013 at 6:31

Bhadra · Accepted Answer · 2013-11-30 07:10:50Z

2

SET @i=0;
SELECT content , @i := @i +1 AS NewOrder
FROM sample
order by arrange

in PHP, read dr['NewOrder'] and update it to db?

edited Nov 30, 2013 at 7:10

Bhadra

2,1041 gold badge13 silver badges19 bronze badges

answered Nov 30, 2013 at 6:58

Nikhil Kudtarkar

1698 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sorting data elements and displaying with php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related