posting records to table

[rayzun]

Im building a PHP page where Im allowing visitors to input information using a online form.

With MySql

The table is got the first field primary (id)
1-8000 records

there are another 22 empty fields in this table.
year, color etc...

each (id) field is unique to a product model

Im asking how is it possible to post
multiple entries to the unique (id) field?

I would then be able to query the table and display entry after entry for the unique id field

[amchargue]

does the table look something like

---

| ID | YEAR | COLOR | FIELD4 | FIELD5 |
0001 | 2003 | red | data4 | data5
0002 | 2004 | blue | data4 | data5
0003 | 2005 | green | data4 | data5
.
.

.

then ... what do you want to do? not sure I understand.

[rayzun]

I really need some help on this question
Some how I think cross referenceing two tables is my answer but Ive yet to figure it out for my purpose.

I have a table and the first field is 'ID'
can I make like a sub-entry table per line...

fields

ID ..... Color ..... Year ..... Seller

data
2 ...... Orange .. 2005 .... Private
454 .. Green .... 1999 .... Private
..
5000 etc

My website needs a form which will post data to a singular 'ID' the form will use mostly select option - form, eventually adding multiple image upload using the same form.
All uploading to MySQL..

My question is how can mutiple visitors post to one 'ID'
This would allow more than one instance recorded for a singular 'ID', the field 'ID' would need 1-10 sub-entries I guess..

#####

If my explaination sucks, I have got this idea where in each field the data when updated adds to the original data and could be comma delimited.. and I could use a query ????

SELECT * FROM mytable WHERE id LIKE '$page' LIMIT 0 , 10

$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result))

{
echo $row[id = 1];
echo "<br>";
echo $row[id = 2];
}

Thanks for any thoughts

-
GooD Day