query a formulazione variabile

[metatad]

              if ($area == "null" && $tag == "null" && $kind == "null" && data == "0000-00-00") {
                echo "[b]<font color=\"#0279d1\">Warning!</font>[/b]
You haven't select any item for your search.
Please, <a href=\"search.php\">try again</a>.";
                } else if ($area !== "null" && $kind == "null" && $tag == "null" && $data == "0000-00-00") {
            $condition = "`area` = '$area'";
                } else if ($area == "null" && $kind !== "null" && $tag == "null" && $data == "0000-00-00") {
            $condition = "`kind` = '$kind'";
                } else if ($area == "null" && $kind == "null" && $tag !== "null" && $data == "0000-00-00") {
            $condition = "`tag` = '$tag'";
                } else if ($area == "null" && $kind == "null" && $tag == "null" && $data !== "0000-00-00") {
            $condition = "`deadline` >= '$data'";
                } else if ($area !== "null" && $kind == "null" && $tag == "null" && $data !== "0000-00-00") {
            $condition = "`deadline` >= '$data' AND `area` = '$area'";
                } else if ($area == "null" && $kind !== "null" && $tag == "null" && $data !== "0000-00-00") {
            $condition = "`deadline` >= '$data' AND `kind` = '$kind'";
                } else if ($area == "null" && $kind == "null" && $tag !== "null" && $data !== "0000-00-00") {
            $condition = "`deadline` >= '$data' AND `tag` = '$tag'";
                } else if ($area !== "null" && $kind !== "null" && $tag == "null" && $data == "0000-00-00") {
            $condition = "`kind` = '$kind' AND `area` = '$area'";
                } else if ($area !== "null" && $kind == "null" && $tag !== "null" && $data == "0000-00-00") {
            $condition = "`tag` = '$tag' AND `area` = '$area'";
                } else if ($area == "null" && $kind !== "null" && $tag !== "null" && $data == "0000-00-00") {
            $condition = "`kind` = '$kind' AND `tag` = '$tag'";
                } else if ($area !== "null" && $kind !== "null" && $tag !== "null" && $data == "0000-00-00") {
            $condition = "`kind` = '$kind' AND `area` = '$area' AND `tag` = '$tag'";
                } else if ($area !== "null" && $kind !== "null" && $tag == "null" && $data !== "0000-00-00") {
            $condition = "`kind` = '$kind' AND `area` = '$area' AND `deadline` >= '$data'";
                } else if ($area == "null" && $kind !== "null" && $tag !== "null" && $data !== "0000-00-00") {
            $condition = "`tag` = '$tag' AND `kind` = '$kind' AND `deadline` >= '$data'";
                } else if ($area !== "null" && $kind !== "null" && $tag !== "null" && $data !== "0000-00-00") {
            $condition = "`tag` = '$tag' AND `kind` = '$kind' AND `area` = '$area' AND `deadline` >= '$data'";
                }
            $result7 = mysql_query("SELECT * FROM `news` WHERE $condition ORDER BY `news_id` DESC");
            //$result7 = mysql_query($result7) or die (mysql_error()."
Query: ".$result7);
                         while($row7 = mysql_fetch_array($result7)) {
                        $tit = $row7["title"];
                        $txt = $row7["text"];
                        $tg = $row7["tag"];
                        $kd = $row7["kind"];
                        $dead = $row7["deadline"];
                        $loc = $row7["location"];
                        echo "[b]<a href=\"" . $page . "?news=" . $row7["news_id"] . "&from=search\"><font color=\"#0279d1\">" . $tit . "</font></a>[/b]
[i]" . $txt . "[/i]
<font size=\"-1\">Tag: <font color=\"#FF0000\">[b]" . $tag . "[/b]</font>
Area: <font color=\"#FF0000\">[b]" . $loc . "[/b]</font>
Kind: <font color=\"#FF0000\">[b]" . $kind . "[/b]</font>" . $dline . "</font><hr>";
                            }