I (currently) have 4 color columns (color1, color2, color3, color4) and I would like the below to echo a value for each “color%” column that is populated. I.E., if color1 = Red, color2 = Green, color3 = , color4 = , then I would like it to output “Colors: Red, Green”

Currently it does not output

$query = mysqli_query($conn,”SELECT * FROM Single Where weave LIKE ‘$weave’ AND pattern LIKE ‘$pattern’ AND series LIKE ‘$series’ AND (color1 LIKE ‘$color1’ or color2 LIKE ‘$color1’ OR color3 LIKE ‘$color1’ OR color4 LIKE ‘$color1’) AND (color1 LIKE ‘$color2’ or color2 LIKE ‘$color2’ OR color3 LIKE ‘$color2’ OR color4 LIKE ‘$color2’) AND type LIKE ‘$type’ ORDER BY name”);

$i=0;
while($row = $query->fetch_assoc())
{
    echo "<figure class='item'>";
    echo "<figcaption class='caption'><H1>$row[name]</H1></figcaption>";
    echo "<a href='$row[image]'><img src='$row[image]'/><a>";
    echo "<figcaption class='caption'>Weave: $row[weave]</figcaption>";
    echo "<figcaption class='caption'>SWG: $row[gauge]   ID: $row[innerdiameter]</figcaption>";
    echo "<figcaption class='caption'>Colors:";
    while (strpos($key, "color") !== FALSE)
    {
        echo "$row[color%]";
    }
    echo "</figcaption>";
    echo "<figcaption class='caption'>Color Pattern: $row[pattern]</figcaption>";
    echo "<figcaption class='caption'><br></figcaption>"; 
    echo "<figcaption class='caption'>$row[description]</figcaption>";
    echo "</figure>";      
}

I have tried while, foreach, and if statements. All of the statements just do not output.