// Variables

$php_artist = $_POST["rma_artist"];





/*

* a simple query to know if the artist exists in the DB by its name, since we won't get the id value.

* if $numrows > 0, we have a match. We calculate the number of likes and then, we update.

* else, we insert.

*/

$query = "SELECT like_score FROM rma_likelist WHERE like_artist = '$php_artist'";

$result = mysql_query($query);

$row = mysql_fetch_assoc($result);

$numrows = mysql_num_rows($result);



// UPDATE if there is a row that matches, we update

if ($numrows > 0) {

        $newLikeScore = $row["like_score"] + 1;

        $query = "UPDATE rma_likelist SET like_score = '$newLikeScore' WHERE like_artist = $php_artist";



        if ( !mysql_query($query, $mysql_connection) ){

            die('ERROR: '. mysql_error() );

        }



        // id, name, likes, operation

        $response = $php_artist_id.":::".$php_artist.":::".$newLikeScore.":::MYSQL UPDATE SUCCESSFULL";

}

// INSERT if no rows match, we insert a new record

else {

        $query = "INSERT INTO rma_likelist (like_artist, like_score) VALUES ('$php_artist', '1')";



        $message = "INSERT SUCCESSFULL, 1 Record Added";



        if ( !mysql_query($query, $mysql_connection) ){

            die('ERROR: '. mysql_error() );

        }



        $new_id = mysql_insert_id();



        // id, name, likes, operation

        $response = $new_id.":::".$php_artist.":::1:::MYSQL INSERT SUCCESSFULL";

}







echo $response;



?>