sort order

nigell wrote:
> I have built a Content Management System which stores information in the
> database. In it i have created a sort order field so that the user can
> choose what order the links appear in a section (instead of sorting by
> primary key for example).
>
> My question is, how can i create a page which will be a form with the links
> to the section with a text box that the user can put a number from 1 to 100
> and then save this to sql.
>
>

That seems like a fairly broad question; are you having trouble with a
specifc part of this task?

I'm assuming that you know how to create HTML forms, and then
subsequently store the submitted information in the database, as your
CMS must do that, right? So, you just ahve another text input that is
the "order number" and store that in your CMS database.

I guess if you could be more specific, we could be of more help.

-Kurt Milligan

ok, what i want is to have a page which lists a section, for example a
section on Web Services
within that section i have several pages, such as ecommerce, design, etc.

I want to list those pages down a screen and then have a text box at the end
of each which i can enter a number from 1-100 to be used as the sort order
in they way the pages appear in the navigation. I dont have a prob with
building forms, html etc. i guess i just need a way to get what i guess is
an array of the form data into mysql.


"Kurt Milligan" <kurt@atNOSPAMmilliganshome.net> wrote in message
news:iESdnZ5Ctem7KJOiXTWJhQ@comcast.com...
> nigell wrote:
> > I have built a Content Management System which stores information in the
> > database. In it i have created a sort order field so that the user can
> > choose what order the links appear in a section (instead of sorting by
> > primary key for example).
> >
> > My question is, how can i create a page which will be a form with the
links
> > to the section with a text box that the user can put a number from 1 to
100
> > and then save this to sql.
> >
> >
>
> That seems like a fairly broad question; are you having trouble with a
> specifc part of this task?
>
> I'm assuming that you know how to create HTML forms, and then
> subsequently store the submitted information in the database, as your
> CMS must do that, right? So, you just ahve another text input that is
> the "order number" and store that in your CMS database.
>
> I guess if you could be more specific, we could be of more help.
>
> -Kurt Milligan
>

that is what i was thinking but couldnt think of how to write it

thanks for your help




> for(...loop through db rows...)
> {
> echo "$page_name <input type=text name='ord_".$page_id."'
> value='".$page_order."'><BR>";
> }
>
> then, on the submit, you just have to loop though the post vars and
> update your database, like:
>
> foreach($HTTP_POST_VARS as $key => $val)
> {
> if(substr($key,0,4) == 'ord_')
> {
> $page_id = substr($key,4);
> $query = "update table set page_order = $val where page_id = $page_id";
> .....execute query, etc...
>
> }
> }
>
> hth