function insert() { global $database_table_prefix; if (!empty($this->artist)) { $result = mysql_query("\n\t\t\t\tSELECT *\n\t\t\t\tFROM `" . $database_table_prefix . "artist`\n\t\t\t\tWHERE `name` = '" . addslashes($this->artist) . "'\n\t\t\t") or die(mysql_error()); if (mysql_num_rows($result) == 0) { $artist = new artist(); $artist->name = $this->artist; $artist->insert(); $this->artist_id = $artist->id; } else { while ($data = mysql_fetch_object($result)) { $this->artist_id = $data->id; } } } if (!empty($this->album)) { $result = mysql_query("\n\t\t\t\tSELECT *\n\t\t\t\tFROM `" . $database_table_prefix . "album`\n\t\t\t\tWHERE `name` = '" . addslashes($this->album) . "'\n\t\t\t\tAND `artist` = '" . addslashes($this->artist_id) . "'\n\t\t\t") or die(mysql_error()); if (mysql_num_rows($result) == 0) { $album = new album(); $album->name = $this->album; $album->artist = $this->artist_id; $album->insert(); $this->album_id = $album->id; } else { while ($data = mysql_fetch_object($result)) { $this->album_id = $data->id; } } } $result = mysql_query("\n\t\t\tINSERT \n\t\t\tINTO `" . $database_table_prefix . "song`\n\t\t\t( `name`\n\t\t\t, `rating`\n\t\t\t, `play_count`\n\t\t\t, `artist`\n\t\t\t, `album`\n\t\t\t)\n\t\t\tVALUES \n\t\t\t( '" . addslashes($this->name) . "'\n\t\t\t, '" . addslashes($this->rating) . "'\n\t\t\t, '" . addslashes($this->play_count) . "'\n\t\t\t, '" . addslashes($this->artist_id) . "'\n\t\t\t, '" . addslashes($this->album_id) . "'\n\t\t\t)\n\t\t") or die(mysql_error()); $this->id = mysql_insert_id(); }