refer an ALL option

[baitubai]

I add an "ALL" option in the select menu. But there is no "ALL" in the mysql table. When I do the query, how can I refer to it?
Any help is appreciated.

[Sxooter]

What you want to do is include something like ALL in the select box, and then test for it:

if ($checkboxvalue="All"){
  $query = "select * from table";
} else {
  $query = ...  The query you have now.
}

[baitubai]

I have this line
echo $q;
to see what the sql will look like.
I tried your way, it give me no data.
And the sql is :
SELECT ... FROM logs WHERE host='all' AND program=....;

[baitubai]

I have these multiple drop down menus, and each of them needs an "all" option. what shall I do to create it and how mysql will look like to get the data when selecting this option?

HELP!