Douglas

<?php

$id = $_GET["id"];

require_once("./edit_nav.php");

if ($add) {

$track_count = "SELECT COUNT(title)
        FROM tracks
        WHERE albums_id = '$id'";
        foreach($dbh->query($track_count) as $row) {
                $track_count = ($row[0]);
                $track_count = ($track_count + 1);
        }

$add_track = "INSERT INTO tracks
        SET albums_id = '$id',
        number = '$track_count'";
        $dbh->exec($add_track);
}

if ($tracks_name && $submit == "Update Tracks") {
        foreach ($tracks_id as $key => $value ) {

                        $query1 = "UPDATE tracks
                        SET number = '$tracks_number[$key]',
                        title = '$tracks_name[$key]',
                        length = '$tracks_duration[$key]'
                        WHERE id = '$key' ";
                        $dbh->exec($query1);
        }
}

print("
<form method='post' action='./tracks.php?id=$id'>
<table>

<tr>
        <td colspan='3'>
        <input type='submit' name='Update Tracks' value='Update Tracks'> <input type='submit' name='add' value='Add New Track'>
        </td>
</tr>

<tr>
        <td><b>
        #
        </></td>
        <td><b>
        Title
        </b></td>
        <td><b>
        Length
        </b></td>
</tr>

");

$query = "SELECT id, albums_id, number, title, length
FROM tracks
WHERE albums_id = '$id'
ORDER BY number";

$x = 0;
$dbh->query($query);
foreach($dbh->query($query) as $row) {
        $tracks_id = stripslashes($row[0]);
        $albums_id = stripslashes($row[1]);
        $tracks_number = stripslashes($row[2]);
        $tracks_name = stripslashes($row[3]);
        $tracks_duration = stripslashes($row[4]);

print("<tr height='20'>
        <td align='left' width='20'>
        <input type='text' name='tracks_number[$tracks_id]' value='$tracks_number' size='4'>
        </td>
        <td align='left' width='20'>
        <input type='text' name='tracks_name[$tracks_id]' value='$tracks_name' size='50'>
        </td>
        <td>
        <input type='text' name='tracks_duration[$tracks_id]' value='$tracks_duration' size='4'>
        <input type='hidden' name='tracks_id' value='$tracks_id'>
        </td>
        </tr>
        ");
        ++$x;
}

print("
</table>
</form>

");

?>