Form Validation Forum :: Customizable Links in PHP & Insert Multiple Rows

I want to build an admin area for my customer where they can enter their own links and then choose the order where that link will be positioned vertical in the left navigation.  

I guess I would have few textboxes with an order dropdown list to the right for the insert.  ie.

Link 1:   [ textbox 1 ]  [ dropdown list from 1 to 5 to choose the postion of the link ]

Link 2:   [ textbox 2 ]  [ dropdown list from 1 to 5 to choose the postion of the link ]

Link 3:   [ textbox 3 ]  [ dropdown list from 1 to 5 to choose the postion of the link ]

Link 4:   [ textbox 4 ]  [ dropdown list from 1 to 5 to choose the postion of the link ]

Link 5:   [ textbox 5]  [ dropdown list from 1 to 5 to choose the postion of the link ]

So, my customer would enter in the data.

Link 1:  About US  2
Link2:  Contact Us  5
Link 3:  Products  3
Link 4:  Support  4
Link 5:  Home 1

So the order would be:

Home
About US
Products
Support
Contact Us.

At the very least I need three columns in db table: id, display_text, position.

How do I go about insert each field, display_text and position in to the MySQL db as mutiple rows from one form.

For example:

id                display text               position

1                 About Us                        4

2                 Contact Us                     2

3                 Products                        1

And so on.

Hello,

You could use the Move Up/Down feature in the NeXTensio list and forms to manage the order of the records.

Regards,
Razvan RACASANU

Thanks.  I was wondering how to insert one form with your controls that would create a new row each time in the database that would insert the links fields instead of having to insert each one of the links one at a time.

So, my form would be.

Link 1:   [ textbox 1 ]  [ dropdown list from 1 to 5 to choose the postion of the link ]

Link 2:   [ textbox 2 ]  [ dropdown list from 1 to 5 to choose the postion of the link ]

Link 3:   [ textbox 3 ]  [ dropdown list from 1 to 5 to choose the postion of the link ]

Link 4:   [ textbox 4 ]  [ dropdown list from 1 to 5 to choose the postion of the link ]

Link 5:   [ textbox 5]  [ dropdown list from 1 to 5 to choose the postion of the link ]

Submit Btn

Data entered:

Link 1:  About US  2
Link2:  Contact Us  5
Link 3:  Products  3
Link 4:  Support  4
Link 5:  Home 1

Submit Btn

Then in the Database it would be with five new rows:

id     display text      position

1      About US             2
2      Contact Us          5
3      Products             3
4      Support              4
5      Home                  1

Thus, in the front end I can query the OrderBy position from the table.

Hello,

You could do this using the Multiple Insert Feature in NeXTensio, except for the choosing directly on which position the record should be which is not supported by NeXTensio.

Regards,
Razvan RACASANU