PHP帮助构建查询

Question

I have several drop lists where if no option is selected then the value is = ""...

I cant figure out how to build the query for mysql in PHP.

query = SELECT * FROM db

Answer 1

Too less information, but here's what I would do

$rows = $db->query(
  'select * 
   from 
     table 
   where 
      checkbox_value = ?',
  $_POST['checkbox']
);

In $rows you will have all the data you need.