PHP / MySQL / Arrays HELP Please !!!!!

[chuckie]

Im Trying to catalogue all my music albums, I have 3 tables - Artists, Albums, Tracks. The first two are working fine but every album have a different amount of tracks. So i have added a add track button which adds an extra row to the php page so i can enter extra tracks.

This row consists of "atrackid, Title, Length" the table in the database also has a track id which increments when a new track is added. The 'atrackid is track no on the album.

The problem im having is the building the array up to assign numbers to the text boxes on the form when i add an extra row. Then taking the information out of the from and putting it into the array so i can then take the info out of the array and place it into tracks table.

After many hours i have only succeded to give my self a head ache

[zak]

My advice...

First thing first, get yourself a copy of postgresql. 😃

Then go to http://www.postgresql.org/idocs/index.php?arrays.html and have a look at those array features. Nice...

Postgres is the daddy...

[ahundiak]

The key thing here is that html names that end in [] will get posted as php arrays.

So you need to make a form like
<form ... rest of stuff ...>
<tr>
<input type="hidden" name="track_id[]" value="$track_id">
<input type="text" name="track_title[]" value="track_title">
</tr>
<tr>
Repeat the input fields for the next track
</tr>

That's very rough html but you get the idea.
When the data is posted
$track_id = $POST['track_id'];
$track_title = $POST['track_title'];

for($i = 0; $i < count($track_id)l $i++)
{
update each track record using $track_id[$i]
}