Unable to fetch db data in proper format for PHP in_array()

check this, i think it should work for you

$colors_love_Array = array();
$result = mysql_query("SELECT * FROM style WHERE style.user_id = $user_id") or die(mysql_error());

while ($row_profile = mysql_fetch_array($result)) {
// I've tried both of these, both separately and together
$colors_love_Array[] = $row_profile['colors_love'];
}

$newColorsArray = explode(",", implode($colors_love_Array));

if(in_array($Color, $newColorsArray)){
echo "Matches: ".$Color;
}

Shouldn't your result be an array, rather than a string separated by commas?

Anyway, with your result as var_dumped above.

$parts = explode( ',', trim( $colors_love_Array ) );
if( in_array( 'Black', $parts ) )
    echo "is here\n";

But I would imagine you actually want to get this:

"Black,Charcoal,Light_Gray,White,Royal_Blue,Dodger_Blue,Red"

as an array. Since I do not know what is in your DB, I cannot offer advice in that area.

Your approach is a bit wrong. The code is storing all of the colors as a string, although you receive them as an array. Therefore you need to use strpos to search through the string for a specific occurrence of another string - i.e. does the string contain Black anywhere. Using this approach will make your life quite harder if for example later you need to be able to sort the colors in a specific way.

As @Adam Sinclair suggested, because the data is contained as a string, you can use preg_match to check if the string contains a color. Unfortunately preg_match is quite an expensive function and should be used wisely and as a last resort.

Also, I would suggest you use PDO and prepared statements for your connections to the database - you don't want SQL injections, right?

In my opinion, the better way of achieving your task is using code similar to the one below:

<?php    
// Host
$hostname = 'localhost';

// Database
$database = 'database';

// Username
$username = 'user';

// Password
$password = 'pass';

// Connection DSN.
// http://php.net/manual/en/ref.pdo-mysql.connection.php
$dsn = 'mysql:host='.$hostname.';dbname='.$database;

try {
    // Create a database connection using PDO
    $db = new PDO($dsn, $username, $password);

    // The value of the user_id (i.e. $_SESSION['user_id'])
    $user_id = 1301;

    // Get all colors, liked by a specific user.
    $query = $db->prepare('SELECT * FROM style WHERE style.user_id = :user_id');
    // Bind the value of $user_id to :user_id in the query.
    $query->bindValue(':user_id', $user_id);
    // Execute the query
    $query->execute();

    // Gets all results for a specific database column (i.e. 'color_loves').
    // In my table, I had color_id, user_id, color_loves, therefore the desired index is 2.
    // NOTE: Remember array indexes start counting from 0.
    $colors = $query->fetchAll(PDO::FETCH_COLUMN, 2);

    // The output of the above will be something similar to this:
    // array(5) { [0]=> string(5) "Black" [1]=> string(8) "Charcoal" [2]=> string(10) "Light_Gray" [3]=> string(5) "White" [4]=> string(10) "Royal_Blue" }

    $color='Black';
    if (in_array($color, $colors)) {
        echo "Matches: ", $color;
    }
    // Outputs Matches: Black

    // Disconnect from the database.
    $db = null;
}
catch(PDOException $e)
{
    // Output any exception messages that might occur
    echo $e->getMessage();
}

?>

As you can see - it's simple, clean, secured and extendable. No need of hard-to-read regex, exploding/imploding strings fron/to arrays and etc. And if in future, your task evolves and the colors need to be sorted, you can easily do that by readying the manual.