Repeat region update page / form PHP

[Guest]

As part of our website's control panel we have a page that displays all of the training courses we offer. This is done by pulling info from mysql db using a repeat region sorted by the course order also in the db.

My question is if I wanted to change the order on all the courses displayed by the repeat region, how to create a page that will update the data base?

My thoughts are this would involve having a hidden field to store the recordID or in my case courseID, but I am not sure how to update each displayed course with one submit button.

Any suggestions?

[Newsgroup_User]

this so much depends on what other fields you have in your table.
Of course ther is the _id
or if you have it the _coursenumber
or my favorite _sortOrder

just decide on the field, or fields and set the sort order in the mtSQL
query.

ORDER BY _fieldName ASC

Jeff
"cdembek" <webforumsuser@macromedia.com> wrote in message
news:f59ovo$1o0$1@forums.macromedia.com...
> As part of our website's control panel we have a page that displays all of
> the
> training courses we offer. This is done by pulling info from mysql db
> using a
> repeat region sorted by the course order also in the db.
>
> My question is if I wanted to change the order on all the courses
> displayed by
> the repeat region, how to create a page that will update the data base?
>
> My thoughts are this would involve having a hidden field to store the
> recordID
> or in my case courseID, but I am not sure how to update each displayed
> course
> with one submit button.
>
> Any suggestions?
>

[Guest]

I have the display order for the repeat region correct it is ASC by courseorder

However the page that displays all the courses I have it so you can change the course order number. Did this by placing a text field and have it load via dynamic data from the DB aka coursorder

what I am trying to do is update the records "courseorder" via that one page

I hope this explains things better

[Guest]

Hi -- did you ever get this figured out? I have the same issue.