There must be a better way how to do it but this is what I would do: (Not
tested--just the "idea"...)
Instead of $var1, $var2... I'd use an array for the drop downs thus,
$var[]
$var[]
$var[]
$var[]
Then, check if any is set, then... anyway, this is how it goes:
// from here
$query = "SELECT foo ";
$query .= "FROM bar";
if (isset($_POST['var']){ // if POSTed
$its_set = 1; // my super "switch"
foreach ($var as $key => $value){
if ($its_set == 1){
$query .= " WHERE thus = '" . $value . "'";
$its_set = 2; // just to make sure "WHERE" is only added once
} else {
$query .= " AND thus = '" . $value . "'";
}
}
}
HTH,
-E
>
>So these 4 variables walk into a bar.... :^]
>
>I have a form with 4 drop downs. Each of these drop downs might have a
value
>and there is no order in which they might have a value. A query needs to
>built (the WHERE and AND portions) that takes into account which ever
>variables have been set. A user may choose a variable that would not be in
>the first location.
>
>$var1 = is not set
>$var2 = is set
>$var3 = is set
>$var4 = is not set
>
>(or any other combination) The query, of course, needs to be in order
taking
>into account the above example;
>
>$query = "SELECT foo ";
>$query .= "FROM bar ";
>$query .= "WHERE thus = '" . $var2 . "' ";
>$query .= "AND thus = '" . $var3 . "' ";
>
>If three of the variables are set then there would need to be an
additional
>AND statement, etc. It would be foolhardy to construct an if or case
>statement that would take into account each possible combination. I have
>been thinking this through for an hour or so, but I am not seeing a clear,
>elegant, and efficient piece of code. Has anyone done anything like this,
or
>does anyone have an idea of how this might be done?
>
>TIA!
>
>Jay
>
>*****************************************************
>* Texas PHP Developers Conf Spring 2003 *
>* T Bar M Resort & Conference Center *
>* New Braunfels, Texas *
>* Contact [EMAIL PROTECTED] *
>* *
>* Want to present a paper or workshop? Contact now! *
>*****************************************************
>
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
_________________________________________________________________
ウィルスメール、迷惑メール対策なら MSN Hotmail http://www.hotmail.com/JA
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
