Re: [mv] Searching multiple columns in MySQL problem

[Dan Busarow <dan@dpcsys.com>]

On Wed, 20 Oct 1999, Daniel Ceregatti wrote:
> This is just straight cgi...I know how to do this. I need to know how to do this with minivend tags, so minivend parses the results via results.html...I appreciate the try, though. :)

I'd put the search in a custom page instead of the standard results page.
Then you can just build the select statement yourself.  I haven't done
this using standard input fields but I believe you can reference any
cgi var via [value cgi-variable]

[sql type=list 
   query="select * from atable where field1 like '% [value inputfield] %' 
   or field2 like '% [value inputfield] %'"]

Dan
-- 
 Dan Busarow                                                  949 443 4172
 Dana Point Communications, Inc.                            dan@dpcsys.com
 Dana Point, California  83 09 EF 59 E0 11 89 B4   8D 09 DB FD E1 DD 0C 82