artfuldrone

Here's my situation: I am building a lyrics database for a project. I'm now working on a page where I can add albums. Firsty, I enter how many tracks are in the album, and from there I enter the songs. What my problem is, is that I somehow need to grab all post values (eg. tracks) from the form, and modify them and insert the values into a MySQL query. So if the album only had 4 songs, the query would look like this: insert into albums_table (track1, track2, track3, track4) values('$_POST['track1']', '$_POST['track2']', '$_POST['track3']', '$_POST['track4']') Of course if the next album had 12 songs the query would need to change. I'd also like to add a few functions to the values like 'trim' and 'ucwords'. As much help as possible will be greatly appreciated.