[FX.php List] Boolean-type searches

[DC]

is there a FAQ? this should be question #1. also, is there a list 
archive? ah yes, there it is:

http://www.iviking.org/mailman/listinfo/fx.php_list

oh shit. it's not searchable.

well....

there is no simple way to do this. choose your poison.

1. write a script in FMP and run the script from FX.php. the result set 
after the script runs should be your set.

2. return one set of results from a wider search and cull the results in 
a foreach loop in PHP.

3. return two sets of results and merge/cull them in PHP.

4. do a combination.

hey guys, did i forget anything?

dan

Carl Anderson had written:
> Good day, list.
> 
> I apologize if this is academic, or is written in some obvious place that
> I've overlooked.
> 
> I'm trying to query a database with two fields, let's say: Points and
> Status.
> 
> I'm looking to search for something like the following (pseudo-codish):
> 
> Status = 1 AND (Points = 0 OR Points = "")
> 
> Sadly, I have no clue how to do this with FX.php--seems if I do a logical
> OR, then I end up with:
> 
> Status = 1 OR Points = 0 OR Points = ""
> 
> Can someone point me in the right direction?  I really need it to be
> X=1 AND (Y=0 OR Y="")
>