Mine

<?php
include("includes/db.php");
include("includes/header.php");
include("includes/leftbar.php");	
?>

<?
if($_POST['submit']){

 $artist = $_POST['artist'];
 $album  = $_POST['album'];
 $lyrics = $_POST['lyrics'];
 $song = $_POST['song'];



//Check if Artist is Unique, If not - submit record. 
$query = "SELECT artist_name FROM artist WHERE artist_name = '$artist'";
$rows = mysql_query($query);
if(mysql_num_rows($rows) == 0){
  $query = "INSERT INTO artist SET artist_name = '$artist'";
  mysql_query($query); 
} 

         
//Check if Album is Unique, If not - Submit Record
	$query = "SELECT album_name FROM album WHERE album_name = '$album'";
       
	$rows = mysql_query($query);
	if(mysql_num_rows($rows) == 0){
           $query = "INSERT INTO album (album_id, album_name) VALUES ('','$album')";
           mysql_query($query); 
        } // IF

//Check if Song is Unique, If not - Submit Record
       $query = "SELECT song_name FROM song WHERE song_name = '$song'"; 
      
	$rows = mysql_query($query);
	if(mysql_num_rows($rows) == 0)(         
        $query = "INSERT INTO song (song_name, song_lyrics) VALUES ('$song','$lyrics')";
         mysql_query($query) or die(mysql_error());
       } // IF


//Now Build querys to extract id's.

$artistidquery = "SELECT artist_id FROM artist WHERE (artist_name = '$artist')";
$albumidquery  = "SELECT album_id FROM album WHERE (album_name = '$album')";
$songidquery = "SELECT song_id FROM song WHERE (song_name = '$song')";


///RUN querys and insert id's into there respective tables.
$artistresult = mysql_query($artistidquery)or die(mysql_error());
$albumresult = mysql_query($albumidquery) or die(mysql_error());
$songresult = mysql_query($songidquery) or die(mysql_error());

$artistid = mysql_result($artistresult, 0);
$albumid = mysql_result($albumresult, 0);   
$songid  = mysql_result($songresult, 0);


// Insert into Artist/Album
mysql_query("INSERT INTO artistalbum (artist_id, album_id) VALUES ('$artistid','$albumid')");

// INSERT into Song/Album
mysql_query("INSERT INTO songalbum (song_id, album_id) VALUES ('$songid', '$albumid')");

//INSERT INTO Song/Artist
mysql_query("INSERT INTO songartist (song_id, artist_id) VALUES ('$songid', '$albumid')");

print "<h1>Thanks for submitting the lyrics too $song by $artist";

}else{ 
?>
        <h1>Submit Lyrics</h1>
	<form action="<?=$_SERVER['PHP_SELF'];?>" method="POST">

			<label for="Artist">Artist</label>
			<input id="artist" name="artist" /><br />

			<label for="Album">Album</label>
			<input id="album" name="Album" /><br />
		
			<label for="Song">Song</label>
                        <input id="song" name="Song" /><br />

			<label for="Lyrics">Lyrics</label>
			<textarea id="lyrics" name="lyrics" rows="10" cols="30"></textarea><br />
		        
                        <label for="Submit">Submit</label>
                        <input type="submit" id="submit" name="submit" value="Submit Lyrics"  /><br />
                    </form>
<?php
} // IF


include("includes/rightbar.php");
include("includes/footer.php");
?>