Attribute filter with SELECT ALL

Tuesday 02 May 2006 12:41:55 am

Hi

Im building a search enginge into my Log Database. It currently has 6 search criterias witch can be <i>empty</i> <b>OR</b> <i>not</i>.
So the sorting is done on a attribute_filter basis:
I have got 6 of these:

{def $first = array(190,'=',$avariable)}

wich i wrap into:

{def $searchstring = array( $first , $second[..........] )}

And finally puts into my fetch:

...
'offset', $view_parameters.offset,
'attribute_filter', $searchstring,
'limit', $numberOfObjects ) )} 
...

This works just fine, as long as one of my criterias are <b>NOT</b> empty.
So what i want to do is the following:
My six arrays must be able to contain a SELECT * if the $avariable is not set.
Like this

{def $first = array(190,'=', 'ALL')}

Thanks in advance for all replys.

------------------------------------
Gunnar Birkeland
http://www.enternett.no

</major>
----------------------------
ez-version: 3.9.3.
PHP: 4.4.2-1
MYSQL: 4.0.24