Forms and arrays

[Comlink]

Hi all

I really need your help with the following problem:

I am writing a script that would alow schools to easily post their teams' results on their website. I can't explain the whole scenario, but here is the main lines (say if I need to explain better):

Since the site is bilingual, I have an array storing teamID and then the corresponding names, thus only the ID is stored in the database. I then have a form with 20 or so field that allow you to enter the scores. These fields are in the same order as the array and the name is $result[]. This then creates a nice "resultsarray" in the same order as the teamid array and therefore it is very easy to create a SQL statement and assign the correct teamid to each result.

However, this system is very limited since it would be a great problem if I need to add a new team somewhere in the middle of the array withour reassigning all the id's in the database.

Does anyone have an idea how to bypass this problem!!

Hope to hear from you guys soon and have a great Christmas!

Comlink

[jweissig]

hello,

Can you please post your form and a simple description of what your database looks like.

You might need to simple change the way the database works to allow for feature expandability.

thanks,
- justin

[diego25]

Make your teamID an int field, and not auto increment. This way, when you want to add a team in the middle, just shift (i.e. add 1) the lower part of the teamIDs.

Example:
You have teams
1 A
2 B
3 C
4 D

and you want to add a team E at ID 3. So what you can do is:

UPDATE table SET teamID = teamID + 1 WHERE teamID >= newTeamID

So that will shift teams C and D to IDs 4 and 5. And then you do an INSERT query to insert the new ID 3.

Diego