HTorres
asked on
user to set order to display
HI EVERYONE
So goooooooooood to be back
so... now we have a table, lets say:
id, name, displayorder, some other fields...
so my end user has to add new records and at some point the table is like this.
1. somename, 3, ....
2. somename, 2, ....
3. somename, 1, ....
4. somename, 4, ....
5. somename, 6, ....
we allways use the "displayorder" field when we display all the data.. (select * from sometable order by displayorder)
3. somename, 1, ....
2. somename, 2, ....
1. somename, 3, ....
4. somename, 4, ....
5. somename, 6, ....
but we need to add a new record like this
6. somename, 2, ....
so its displayed in second row.
we need the other records to be reordered (+1) or do something else.
we need the end user to input set the order in wich the new record will be displayed and forget the thing.
i have several hours thinking on this...
as im writing this ... it came to my mind something like this...
(this is not sql, its a draft)
update table where displayorder => $newdisplayorderentered, displayorder= displayorder+1
how can i do something like this ?
thank you in advance.
So goooooooooood to be back
so... now we have a table, lets say:
id, name, displayorder, some other fields...
so my end user has to add new records and at some point the table is like this.
1. somename, 3, ....
2. somename, 2, ....
3. somename, 1, ....
4. somename, 4, ....
5. somename, 6, ....
we allways use the "displayorder" field when we display all the data.. (select * from sometable order by displayorder)
3. somename, 1, ....
2. somename, 2, ....
1. somename, 3, ....
4. somename, 4, ....
5. somename, 6, ....
but we need to add a new record like this
6. somename, 2, ....
so its displayed in second row.
we need the other records to be reordered (+1) or do something else.
we need the end user to input set the order in wich the new record will be displayed and forget the thing.
i have several hours thinking on this...
as im writing this ... it came to my mind something like this...
(this is not sql, its a draft)
update table where displayorder => $newdisplayorderentered, displayorder= displayorder+1
how can i do something like this ?
thank you in advance.
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
works great angelIII !!
Update table set displayorder= displayorder+1 where displayorder >= $newdisplayorderentered
but, if you add a record with displayorder=1, and later you delete it. the first record is the one with displayorder=2
how can i re enumerate all records after someone deletes a record ?
we are already here and glowing, why not to crown this thing...
:)
thank you in advance....
similary, delete the record, then decrease the items after the item deleted:
delete table where displayorder = $delete_displayorderentere
Update table set displayorder= displayorder-1 where displayorder >= $delete_displayorderentere
delete table where displayorder = $delete_displayorderentere
Update table set displayorder= displayorder-1 where displayorder >= $delete_displayorderentere
ASKER
Super!
ASKER
thank you!
ASKER