eCommerce product table design - MySQL
SQL is not my strong point, but this was an interesting question with no answers for such a long period of time.

I would use HTML arrays to set the extra detail:

&lt;input type="text" name="model"&gt; //say AA-1501
&lt;input type="text" name="color[]"&gt; //say red
&lt;input type="text" name="color[]"&gt; //say green
&lt;input type="text" name="color[]"&gt; //say black

&lt;input type="text" name="size[]"&gt; //say 15
&lt;input type="text" name="size[]"&gt; //say 16
&lt;input type="text" name="size[]"&gt; //say 17


On the back end in PHP this will come across as:

&lt;?php 
$model = 'AA-1501';
$color = array(red,green,black);
$size  = array(15,16,17);


Then use your SQL to insert the correct data into the fields you want.

PHP implode, array_walk will help you a bit :)

I understand this won't help you now, but I'm sure someone might find it useful.