How would i create this?..

[AngelJade]

Hi all, new to this site, read a lot of the other topics though and couldn't find an answer so decided to register and ask for myself.

I am trying to create a "Roster" New/Update and Edit page for people to update a Guild/Clan user list.

I've found how to input the data to a SQL table using a normal form, but it's very messy and rather too long and eye hurting.

You can view it here:

I am looking for something that will do the same concept, but allow me to not display all the 40 boxes, jsut one box with a little "Add to list" type feature, the same concept as a shopping cart that will display to the right of the form on a div float.

This question comes in between i'd be guessing Javascript/SQL Database Querys/PHP, i didn't know which forum to chose so i decided to chose SQL as it's the biggest feature in the page.

Any help would be appreciated,
Thank you,
Jade

[chazzy]

posting a link like that doesn't tell us anything about how your database is structured. though, if you have created a table w/ 50 columns, that would explain the issue with this approach. you should probably create a second table to use, that contains a FK w/ the roster information.

[AngelJade]

The table has 43 colums (:eek: i know. :P)

"pmcname"
"pmclogo"
"siteurl"
"player1" ect ect (40 times from 1 to 40)

I am basically wanting to ask if there is any way to allow someone to post in the same kinda way, but in a shopping cart form.

So the user enters a player name, presses Add, the player name gets entered into the first "player1" column, then he can keep adding as many as he needs.

[chazzy]

yes of course, but it's nothing to do with your data model.

all your script has to do is determine what the next space available is, which is done by select * on the table.use that to find the first available slot.