[thelist] SQL user-defined order

Matt Slocum matt.slocum at gmail.com
Wed Oct 10 11:44:49 CDT 2007

I'm actually doing a lot of DOM scripting already. When the user
rearranges the list in the browser I need the changes saved in the
database. There probably won't be more than 50 records, but my
personality wants to do it efficiently.

Also, I'm using AJAX to submit the new arrangement every time there is
a change. So if the user completely rearranges even 50 items, it will
go through all the work for each change.


On 10/10/07, Stephen Rider <evolt_org at striderweb.com> wrote:
> How many records do you expect to be on the field?
> This could be done with PHP (or whatever) that creates and populates
> an HTML form from the existing data.  Throw in some DOM scripting to
> insert/delete/move table rows, and Submitting the form recreates the
> array from the new data.
> If there are a gazillion records, that may not be practical, but
> otherwise might work well.
> Stephen
> On Oct 10, 2007, at 10:52 AM, Matt Slocum wrote:
> > I want the user to be able to decide the order of a list of
> > categories.
> >
> > Does anyone have any ideas?
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

Matt Slocum

More information about the thelist mailing list