Because I spend a lot of time trying to figure out your code, maybe I
just give you mine, you will faster understand how to do what I want.
Two sortable lists (#1 and #2). Both of them are driven by MySQL
database, but each are driven by different MySQL "tables". The
sortable #1 is where I want that "Auto-ID" (as I call it) function to
work. Right now here is my onDrop function (everything is stored in a
different .js file):
The self function of "addItem" is (in a different .class file):
$content = trim($this->mMysqli->real_escape_string($content));
$result = $this->mMysqli->query('INSERT INTO tasks SELECT *
FROM channels WHERE id="' .
$content . '"');
$updatedList = $this->BuildPlaylist();
After it clones a row from one table to another, the list updates. But
I want not only to clone an item, but also give it a corret Id, so
it's not somewhere inside of a sortable but exactly where you've
On May 25, 8:37 pm, Walter Lee Davis <wa...@wdstudio.com> wrote:
> The script contacts the database through the Ajax.Request system in
> Prototype. I can't find the code I posted to you, but all that part
> was in there, I think. It sends a POST to the server with the type of
> item that was dropped, and the server replies by first making a new
> item of that type and then returning the database ID generated in the
> What I'd like you to do is post what you have tried on Pastie or jsbin
> (if the latter, you can mock up the Ajax.Request part and see it
> running, but changing the POST to GET and requesting another jsbin
> page that just returns text).
> I need to see what you're trying before I can suggest another route
> for you to take.
> On May 25, 2009, at 12:04 PM, WLQ wrote:
> > Yeah, but what I don't understand is how your script connects with a
> > database, I mean what are the cart, timeline, cart-active... are? I've
> > noticed we have some trouble understanding one another, can we talk
> > somewhere like msn?- Hide quoted text -
> - Show quoted text -
You received this message because you are subscribed to the Google Groups
"Prototype & script.aculo.us" group.
To post to this group, send email to firstname.lastname@example.org
To unsubscribe from this group, send email to
For more options, visit this group at