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 "