Database Order

[pepps]

Hi

I have just created a dynamic news scroller populated by a database, i am going to create an admin page so users can add new news feeds,

How in the admin page can i change the order of the feeds lets say i wanted to make the data on row 5 belong to row 4 instead, like a move up or down feature.

Is this possible

Thanks

John

[Newsgroup_User]

What you would need to do is have a field in your database called somethinfg
like "order_in_list" and do your sorts on this field. To do the move up/down
you would set a function that altered this number and then refreshed the
page.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"pepps" <webforumsuser@macromedia.com> wrote in message
news:f02p9s$g30$1@forums.macromedia.com...
> Hi
>
> I have just created a dynamic news scroller populated by a database, i am
> going to create an admin page so users can add new news feeds,
>
> How in the admin page can i change the order of the feeds lets say i
> wanted to
> make the data on row 5 belong to row 4 instead, like a move up or down
> feature.
>
> Is this possible
>
> Thanks
>
> John
>

[Newsgroup_User]

Paul Whitham AdobeCommunityExpert wrote:

> What you would need to do is have a field in your database called
> somethinfg like "order_in_list" and do your sorts on this field. To
> do the move up/down you would set a function that altered this number
> and then refreshed the page.


Also you can return data based on order_in_list and date. so if more
than one item has the same order, the newest date will be at top.