I am new to MySQL and would like your opinions and thoughts about constructing a database with forms;
1. The user has to input at least one row but a maximum of 20. Each row consists of about 8 columns. Somehow I would like the user to control the number of fields that will be seen. How do I create a form with adjustable number of rows (which the insert function will detect) ?
2. Each field will then be inserted to the database. The loop or something like that has to find how many fields that are filled in. How do I insert and connect the rows in the best way?
3. When displaying I would like to connect all rows to one link. That link will display all rows. That is, when I search, I only want to see one, general link with info about the row. (I will have name and date as the parameters to find the rows that belong to each other). How do I connect all rows into one?
Thanks / Henrik
1. The user has to input at least one row but a maximum of 20. Each row consists of about 8 columns. Somehow I would like the user to control the number of fields that will be seen. How do I create a form with adjustable number of rows (which the insert function will detect) ?
2. Each field will then be inserted to the database. The loop or something like that has to find how many fields that are filled in. How do I insert and connect the rows in the best way?
3. When displaying I would like to connect all rows to one link. That link will display all rows. That is, when I search, I only want to see one, general link with info about the row. (I will have name and date as the parameters to find the rows that belong to each other). How do I connect all rows into one?
Thanks / Henrik