I have a table of CD releases - each CD has it's own ID.

Then I have a table of the track listings - each track has it's own row, and an ID column linking back to the relevant release

This table's structure is this :

-ID (the ID of the corresponding release in the other table)
-track_url (an optional link to a real audio clip)
-disk (ie if it's a 4CD box set, if it's on the 1,2,3rd or whatever)

Now, my problem is with adding the links to Real AUdio clips to the tracks.

This is the code I'm currently using to go about it, but as you'll be able to see, it's flawed as I cannot work out a way to distinguish each disk, because at the moment there can be this situation :

eg. Release ID 5 has 3 CD's - I want to add a track_url link to track 3 on disk 1, yet my system add's it to all disks.

Here is my code :

PHP Code:

if (!isset($submit)) {


<form action="tracklisting.php" method="post">
<table width="100%" cellspacing="1" cellpadding="2">


$result=mysql_query("SELECT * from releases_tl WHERE ID = '$ID'");

while (
$row mysql_fetch_array($result) ) {


<tr bgcolor='#FFFFFF'>
<td width="20%">
<input type="text" name="track[<?php echo("$row[track_number]"); ?>]">
<td width="80%"><font face="verdana" size="2"><b>
<?php echo("$row[track_name]"); ?>




<tr><td colspan="2" align="left">
<input type="hidden" name="disk" value="<?php echo("$row[disk]"); ?>">
<input type="hidden" name="ID" value="<?php echo("$ID"); ?>">
<input type="submit" name="submit" value="submit">





if ($submit == "submit") {


$key$val) = each($track)) {
if (isset(
$track)) {

mysql_query("UPDATE releases_tl SET

track_url = '
$val' WHERE ID = '$ID' and track_number = '$key' and disk='$disk'


"Tracks added.");
Thanks for the help.