writing varying fields to a database

[dakey]

Hello, i wondered if someone would be able to help me with a personal site i am trying to build. regarding reading and writing to database.

here is the scenario.

The user is presented with a page of empty fields. The number of these fields depends on how many records are being drawn from the database this can vary each time.

so user A might have 8 fields whist user B might have 3 fields

when they fill in the black fields and hit submit it then writes these values back to the same record they came from.

My problem is whilst i have no problem reading from the database and displaying these fields, i don't know how to write them back to the database because i don't know how many fields will be displayed at any given time.

Is there any easy solution to this.

thanks,

Martin

[laserlight]

Instead of varying the number of columns (and thus the fields), vary the number of rows. You need to determine what are the entities that you are dealing with and the relationships between them.

[dakey]

Hi Sorry maybe i didn't explain it properly.

Basically each week users predict the scores of local football matches. So each week site admin enter the weeks fixtures which in turn creates empty rows in the 'predictions' table for each user. So there will be a separate row for each match for each user

This means each week there could be a different amount of matches and therefore different amount of rows each week.

So on the page a field is created for each row in the database which i then need an update sql to update the database. But no knowing how many rows there will be each week i cannot use a normal update.

any help greatly appreciated.

thanks