Inserting multiple lines into table

[spiceydog]

I hope this makes since because I am very confused right now about what I am asking:
I have a website that is for bands to upload and post there songs and such. Right now I am working on the part where you fill out the information for your album to be viewed. So first you have to understand how my table is layed out:
id ¦ album ¦ artist ¦ track ¦ length

So on the page that a user will fill out in order to post there data there will be forms for each of these variables. BUT! There is 5 forms for the track variable because I am expecting people to be uploading entire albums rather than single songs. Now what needs to happen is PHP needs to create 5 lines of data (maybe more or less depending on the size of the album) for the tracks. I don't know if it is a problem but each track form has to have the same value in order for it to correspond to the right place on the MySQL table.

Thanks in advance!

[flann]

Based on the title of your post, it sounds like you're looking for something like this.

insert into tablename (id, album, artist, track, length)
values
(1, 'meteora', 'linkin park', 'Easier to run', '4:56'),
(2, 'meteora', 'linkin park', 'Faint', '3:34'),
(3, 'Hybrid Theory', 'linkin park', 'With you', '5:34');

It would be better for the long run for you to break up your data into multiple tables though and use joins to combine them when needed.

You should have an artist table, an album table with the artist id as a key and a tracks table with album id as a key. This way you'll reduce the amount of redundant data.