I have created a Database driven CD Database, right now, I have adding cd to the db "name and title" after adding the cd you can now add the tracks, But after I add tracks... and click the link on the homepage it shows all tracks for all the cds... My question is, How do I only see the tracks for the selected cd after the link is clicked? Here is the code for the the link: should be (cd_id and trigger and cd_title) [code] <a href='tracks.php?cd_id={$cd3['cd_id']}&tracks&cd_title={$cd3['cd_title']}'>Tracks</a> [/code] Here is the code for the tracks.php page: [code] <html> <head> <?php include 'connect.php'; $cdl = @mysql_query("select * from cds where cd_id={$_GET['cd_id']}"); $cd2 = @mysql_num_rows($cdl); $cd3 = @mysql_fetch_array($cdl); ?> <title>Tracks for [<?php echo "{$cd3['cd_band']} - {$cd3['cd_title']}"; ?>]</title> <link rel="stylesheet" href="style.css" type="text/css"> </head> <body class="UsePageBg"> <a href="index.php">Home</a><br> <?php if (isset($tracks)): ?> <table width="100%" border="1" class="InternalHeader" > <tr> <td width="10%" align="center">CD Band</td> <td width="10%" align="center">CD Title </td> </tr> </table> <?php // get cds include 'connect.php'; $cdl = @mysql_query("select * from cds where cd_id={$_GET['cd_id']}"); $cd2 = @mysql_num_rows($cdl); $cd3 = @mysql_fetch_array($cdl); //get tracks $cd4 = @mysql_query("select * from tracks where cd_id={$_GET['cd_id']}&cd_title={$_GET['cd_title']}"); $cd5 = @mysql_num_rows($cd4); $cd6 = @mysql_fetch_array($cd4); ?> <table width="100%" border="1" cellspacing="0" cellpadding="0" class="NormalTableTwo"> <tr> <td width="10%" align="center"><?php echo "{$cd3['cd_band']}"; ?></td> <td width="10%" align="center"><?php echo "{$cd3['cd_title']}"; ?></td> </tr> </table> <p> <a href="tracks.php?cd_id=<?php echo "{$cd3['cd_id']}"; ?>&addtracks&<?php echo "{$cd3['cd_title']}"; ?>">Add Tracks</a><br> <table width="100%" border="1" class="InternalHeader"> <tr> <td width="10%" align="center">CD Track No.</td> <td width="100%" align="center">CD Track Title </td> </tr> </table> <?php include 'connect.php'; mysql_connect("$server", "$username", "$password") or die (mysql_error()); $result = mysql_db_query($db, "SELECT * FROM tracks order by cd_trackid") or die (mysql_error()); if (mysql_num_rows($result)) { ?> <table width="100%" border="1" cellspacing="0" cellpadding="0" class="NormalTableTwo"> <?php while ($qry = mysql_fetch_array($result)) { echo " <tr> <td width='10%' align='center'>{$qry['cd_trackno']}</td> <td width='100%' align='center'>{$qry['cd_tracktitle']}</td> </tr>"; } } ?> </table> <?php echo "{$cd3['cd_title']}"; ?> </body> </html> <?php endif; ?> <?php if (isset($addtracks)): include("connect.php"); //$cd_id = $_GET["cd_id"]; //$r = @mysql_query("select * from tracks where cd_id='$cd_id'") or die(mysql_error()); //$a = @mysql_fetch_array($r); $cd_title = $_GET["cd_title"]; $t = @mysql_query("select * from cds where cd_title='$cd_title'") or die(mysql_error()); $i = @mysql_fetch_array($t); ?> <title>Add Tracks for [<?php echo "{$cd3['cd_band']} - {$cd3['cd_title']}"; ?>]</title> <p> <form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post"> <input name="cd_id" type="text" value="<?php echo $_GET['cd_id']; ?>" readonly="true"> <input name="cd_title" type="hidden" value="<?php echo "{$cd3['cd_title']}"; ?>" readonly="true"> <table width="100%" border="1" class="InternalHeader"> <tr> <td width="10%" align="center">CD Track No. </td> <td width="100%" align="center">CD Track Title </td> </tr> </table> <table width="100%" border="0" class="NormalTableTwo"> <tr> <td width="10%" align="center"><input name="cd_trackno" type="text" size="5"></td> <td width="100%" align="center"><input name="cd_tracktitle" type="text" size="100"></td> </tr> </table> Adding tracks for <?php echo "{$cd3['cd_band']}"; ?> - <?php echo "{$cd3['cd_title']}"; ?> <br> <input name="save" type="submit" value="Save Tracks"> </form> </p> <?php else: // Connect to the database server include("connect.php"); $cd_id = $_POST['cd_id']; $cd_title = $_POST['cd_title']; $cd_trackno = $_POST['cd_trackno']; $cd_tracktitle = $_POST['cd_tracktitle']; // If CD has been submitted, // add it to the database. if ($save == "Save Tracks") { $sql = "INSERT INTO $table1 SET cd_id='$cd_id', cd_title='$cd_title', cd_trackno='$cd_trackno', cd_tracktitle='$cd_tracktitle'"; if (@mysql_query($sql)) { echo("<P>CD Track(s) (<b>$cd_trackno - $cd_tracktitle</b>) saved.</P><a href=tracks.php?cd_id=$cd_id&tracks&cd_title=$cd_title>DONE</a> | <a href=tracks.php?cd_id=$cd_id&addtracks>Add another Track</a>"); } else { echo("<P>Error saving Track <b>$cd_trackno - $cd_tracktitle</b>:<br> " . mysql_error() . "</P>"); } } endif; ?> [/code] Any help would be greatly appriciated.