PHP/MySQL - Delete from two tables and server files

[megs1328]

Currently, my site is set up so you have to delete all the music and then the band if you want both gone. I'd like to make it so that if a band is deleted, all their music is as well. I am using Dreamweaver CS3

To delete the music only I have an unlink:

if ((isset($_POST['musicID'])) && ($_POST['musicID'] != "")) {
  $image_path = '../includes/audio/';
    if (isset($_POST['trackdirectory']) && file_exists($image_path.$_POST['trackdirectory'])) {
      unlink($image_path.$_POST['trackdirectory']);
      }
  
  $deleteSQL = sprintf("DELETE FROM music WHERE musicID=%s",
                       GetSQLValueString($_POST['musicID'], "int"));
                   
  mysql_select_db($database_everyscene, $everyscene);
  $Result1 = mysql_query($deleteSQL, $everyscene) or die(mysql_error());

  $deleteGoTo = "viewbands.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
    $deleteGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $deleteGoTo));
} 

My delete artist page currently is:

if ((isset($_POST['artistID'])) && ($_POST['artistID'] != "")) {
  $deleteSQL = sprintf("DELETE FROM artists WHERE artistID=%s",
                       GetSQLValueString($_POST['artistID'], "int"));

  mysql_select_db($database_everyscene, $everyscene);
  $Result1 = mysql_query($deleteSQL, $everyscene) or die(mysql_error());

  $deleteGoTo = "viewbands.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
    $deleteGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $deleteGoTo));
} 

Is there a way to add the delete music from a band into the delete a band page? My music table is currently set up as: musicID, track_directory (which links to the server file), artistID (which links to the artist table). Thank you

[megs1328]

Does any of that make sense?

[forum_amnesiac]

Unless I am misunderstanding you have posted here is a simple way to delete all the artists music if the artist is deleted.

if ((isset($_POST['artistID'])) && ($_POST['artistID'] != "")) { 

$artist=$POST['artistID']; 
 
$delartist = "DELETE FROM artists WHERE artistID=$artist";
$delmusic = "DELETE FROM music WHERE artistID=$artist";

$Result1 = mysql_query($delartist) or die(mysql_error()); 
$Result2 = mysql_query($delmusic) or die(mysql_error()); 

You obviously need to open your database before this code, I haven't tested it but it should work.

There are other ways of doing this, by joining the tables, but that is a bit more complicated.