mysql select query based on array value : I have a dynamic array . For example  like this. 

    $color = array('red','blue','green');
    "SELECT * FROM mytable where colors=(red or blue or green)"

But my array is dynamic. So i dont know the values and how can I loop the array and select the rows. PLz help me.
