As you've noted the "post" should give you some feedback like this:

whatever_your_list_ID_is = Array(
        0 => 12,
        1 => 13,
        2 => 24,
        3 => 2,
        4 => 42
)

But it does not return any number on the other side:

Array
(
    [whatever_your_list_ID_is] => Array
        (
            [0] =>
            [1] =>
            [2] =>
            [3] =>
        )

)


> Yes, mysql_query doesn't return a list, it returns a resource  
> identifier. You have to create the list yourself using a loop and  
> mysql_fetch_object or mysql_fetch_array or one of the other "fetchers".
>
> Before we go much further, I need to remind you that this is not a PHP  
> list, and that those things do exist -- that's got to be one of the  
> best* explained languages on earth.
>
> The example I posted was working code ripped out of a busy site.  
> However it relies on the MyActiveRecord ORM to do anything.
>
> define('MYACTIVERECORD_CONNECTION_STR', 'mysql://user:p...@localhost/
> databasename');
> require_once('MyActiveRecord.0.5.php');
> class widgets extends MyActiveRecord{}
> $list = MyActiveRecord::FindAll('widgets',null,'position ASC');
> foreach($list as $item){
>         //print_r($item);
>         //do what you want with $item->name, $item->description...
>
> }
>
> That is all there is to that. Anything else, I really recommend this  
> book: ISBN:0-672-31784-2 (may be -3 now, don't know what the current  
> version is). PHP and MySQL Web Development, by Luke Welling and Laura  
> Thomson. (SAMS)
>
> Walter
>
> *Where by "best" I simply mean "most".
>
> On Jun 13, 2009, at 9:04 AM, WLQ wrote:
>
>
>
> > I've followed your link and tried to build the list as you suggested
> > there. But it gives me.
>
> > "ERRNO: 2 TEXT: Invalid argument supplied for foreach() LOCATION: ...,
> > line 7"
> >http://jsbin.com/elocu/edit
>
> >> Here's a list of problems. (I use database to drive the second
> >> sortable too).
> >> Now, if you drag an item from originals to clones any item but not  
> >> the
> >> first, it will be cloned and "reverted". But you wont be able to move
> >> it (inside of cloned sortable), when you drag and drop one more item,
> >> that item wont move ass well, but previous dropped item apparently
> >> receives the ability of being dragged. What is extremely weir. Here's
> >> one more weirdness, if you drag items from originals in order they
> >> appear, then they will be cloned but won't be "reverted". I've also
> >> added your print_r($_POST) to the update_order.php but it's giving
> >> some unfair results.
> >> I've uploaded the whole pack to a "some" website. Check it 
> >> outhttp://scriptaculous.host22.com/
>
> >> On Jun 8, 1:00 pm, Walter Lee Davis <wa...@wdstudio.com> wrote:
>
> >>> Gaaaaaa! I always get this backward. As Mr. Wonka would say, "Strike
> >>> that; reverse it!"
>
> >>> whatever_your_list_ID_is = Array(
> >>>         12 => 0,
> >>>         13 => 1,
> >>>         24 => 2,
> >>>         2 => 3,
> >>>         42 => 4
> >>> )
>
> >>> Walter
>
> >>> On Jun 8, 2009, at 6:56 AM, Walter Lee Davis wrote:
>
> >>>> The data generated by Sortable.serialize looks like this after PHP
> >>>> grabs it from the POST:
>
> >>>> whatever_your_list_ID_is = Array(
> >>>>    0 => 12,
> >>>>    1 => 13,
> >>>>    2 => 24,
> >>>>    3 => 2,
> >>>>    4 => 42
> >>>> )
>
> >>>> The keys of the array give the position, the values give the  
> >>>> numerical
> >>>> part of the list item ID. So in this case, the list looked like  
> >>>> this
> >>>> in the DOM when serialize() wrapped it up:
--~--~---------~--~----~------------~-------~--~----~
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 prototype-scriptaculous@googlegroups.com
To unsubscribe from this group, send email to 
prototype-scriptaculous+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/prototype-scriptaculous?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to