Thanks for the reply Bastien. Maybe I was not clear though. I am creating a dynamic page with a search query with two options. Lets say the first is by Product. The second is by the Color. I need it so that if the user selects a Product and then chooses not to select the Color, it searches by...
I would like to create a drop down menu in a form that selects distinct arrays from a columname, inserts them into a drop down menu, but then I also want one of the options to be equal to all of the rest. I would end up with a drop down structured like this:
All colors
Red
Blue
Green
Purple...
Sorry about the Red ;o)
I meant to type this:
$query = "SELECT * FROM eny_yarn_identifier WHERE yarnName=\"{$_POST['interest']}\"";
if (isset($yarnColor))
{
$query .= " AND yarnColor=\"{$_POST['interest2']}\"";
}
$result = mysql_query($query)
or die ("Couldn't execute...
I don't know if the title explains my problem very well, but this is what I have:
$query = "SELECT * FROM eny_yarn_identifier WHERE yarnName=\"{$_POST['interest']}\"";
if (isset($yarnColor))
{
$query .= " AND yarnColor=\"{$_POST['interest']}\"";
}
$result = mysql_query($query)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.