adding feilds to a DB to be displayed in a select list
Posted: Mon Sep 10, 2012 11:58 am
Hello
I am getting a bit stressed on this one.
I have an add product form that will be sent to a php MYsql DB.
i need to add sizes and colours of the product them this needs to be displayed in a select list for the end user, ( i can do this bit )
but i need to know the nest way of adding the sizes / colours. the only way i can think of is to manually add example 10 feilds to the product table then have text fields in the form to name the colours / sizes then they can be shown in a select list for the end user.
the trouble with this is the end user can add any more colors if need be and if there are less colors than 10 the select list will show blank lines.
I really need a push in the right direction
thanks in advance
I am getting a bit stressed on this one.
I have an add product form that will be sent to a php MYsql DB.
i need to add sizes and colours of the product them this needs to be displayed in a select list for the end user, ( i can do this bit )
but i need to know the nest way of adding the sizes / colours. the only way i can think of is to manually add example 10 feilds to the product table then have text fields in the form to name the colours / sizes then they can be shown in a select list for the end user.
the trouble with this is the end user can add any more colors if need be and if there are less colors than 10 the select list will show blank lines.
I really need a push in the right direction
thanks in advance