I need your Help

[Anon]

Hallo!!

I am using PHP and MYSQL to develop database. I have a table containing 10 fields. The value of 7 fields are constant but the values of the other 3 fields will vary.

I need 12 rows of those 7 fields for each Item and 12 rows of the 3 fields for the same Item. Again for another Item I use the previous 12 rows of the 7 fields but another 12 rows of the 3 fields and so on...

Is there any short cut to solve this problem? If you couldn't understand my question, I can explain further.

Thank you in advance...

Tsegaye

[bastien]

two tables...one table containing the seven fields and some kind of unique key identifier...the other table will hold the same unqiue key identifier and the three other variables...

this way the static info stays in one table and the variables are all in the other table.....

hth
Bastien