// 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;

 

?>