Need help building form and insterting into MySQL ;)

[jeger003]

hello,

I am trying to create a form that will log items. Say I have a list of fruits and I want to log the fruit and its color. I don't know how many fruits I have so I need the form to start with one row first then add rows after I hit enter.

 

I then need to insert the fruits into mysql

 

any ideas or links? anyone?

 

 

 

 

 

[jeger003]

I know I need to use mysql INSERT INTO. what I want to figure out is how I can make it display another row after one is completed.

[princeofpersia]

you need to create a table for colors

 

lets say

 

id  color

 

 

and another table for fruits

 

id name quantity(box, Kg, etc)

 

 

 

[jeger003]

i have that part set now. the issues im having are from the form itself. I want the form to display new rows once I enter the first fruit. So I enter Red Apple and another box appears for me....i then enter Orange Orange and another box appears....etc how do i do that?

 

 

because each field needs its own ID in order to INSERT INTO mysql  i dont want to make 100 of the same fields with the same ID I want it to automatically do that