Multi Records with a Form

Hi
Iam having a question i searched many threads for solution but i did not ?
My question is
can we update a database with multirows using one form ?
for example :-
from the form below :
Album Name :- album
Composer Name:- Composer
Song: song1
Singer: singer1
Song:song2
Singer:singer1& singer2
Song:Song3
Singer:singer3

I want the above form results to updated in database as below:
uid | Album Name | Composer Name | Song | Singer
1 | album | Composer | Song1 | singer1
2 | album | Composer | Song2 | singer1& singer2
3 | album | Composer | Song3 | singer3

Please answer me is this is Possible?
Please provide me the solution.
Thanks all

Hi chellam,

Yes but you'll need to hand-code the MySQL & PHP to do it. Not difficult but requires some coding knowledge.

Bob

Hi Bob
Realy Very Very Thanks for this much fast reply
Realy🙂
I will try for it
Thank you very much Bob
Chellam