2. PHPRunner General questions
  3. [SOLVED]  Noob question: how do I get the 'Not' checkbox t
This topic is locked
[SOLVED]

 Noob question: how do I get the 'Not' checkbox t

 		11/17/2009 9:32:00 PM
PHPRunner General questions
J
 jrwatsio author

I searched for this basic topic and of course searching for 'Not checkbox' results in a ton of unrelated topics. So on the advanced search form when I check the 'Not' box, the query results still includes checked columns. Am I misunderstanding the function of 'Not' or do I need to add some code to enable it? How do I exclude columns from the query results?

Thanks in advance for any help - I am an asp user migrating to php/mysql.
Sergey Kornilov admin 11/17/2009

To exclude columns from search simply don't enter anything there.
NOT changes search criteria to opposite.
i.e. Make Equals Audi returns all cars where make is Audi (select from cars where make='Audi')

If you check off NOT checkbox next to make it returns all cars but Audi (select from cars where make<>'Audi')
J
 		jrwatsio author 11/18/2009

Ok, that make (obvious) sense now that you've explained it. Thanks.



To exclude columns from search simply don't enter anything there.
NOT changes search criteria to opposite.
i.e. Make Equals Audi returns all cars where make is Audi (select from cars where make='Audi')

If you check off NOT checkbox next to make it returns all cars but Audi (select from cars where make<>'Audi')