Code: Select all
$colors[] = "Black";
$colors[] = "Blue";
$colors[] = "Silver";
$colors[] = "Tan";
$colors[] = "Gold";
$colors[] = "White";
$colors[] = "Red";
for($i=0; $i <= (count($colors) - 1); $i++){
"$query" . $colors[$i] = "SELECT * FROM tblColors WHERE color='" . $colors[$i] . "'";
}$queryBlack = "SELECT * FROM tblColors WHERE color='Black'";
$queryBlue = "SELECT * FROM tblColors WHERE color='Blue'";
etc...
Is this possible? If so, how is it done, because obviously I've missed something.