[mv] Trouble to get my search right!

[jojo@buchonline.net]

******    message to minivend-users from jojo@buchonline.net     ******

Hi list,

I´ve two table "products" and "XYZ".
In table "products", there is a field "XYZ_ID".
Table "XYZ" looks like

ID    name      description
1     jojo      A german boy
2     Joachim   A german boy too
etc.

I´ve a srchform like:
-------snipp---------
<FORM ACTION="[area search]" METHOD=POST>
<INPUT TYPE=hidden NAME=fi VALUE=products>
<INPUT TYPE=text NAME="se" SIZE=20>
<INPUT TYPE=submit VALUE=Search>
<INPUT TYPE=hidden NAME="ml" VALUE=4> 
<INPUT TYPE=hidden NAME="os" VALUE=0> ?????
<INPUT TYPE=hidden NAME="su" VALUE=1>
<INPUT TYPE=hidden NAME="cs" VALUE=1>

<!-- the last part -->
<BR><BR>
Search only any keywords for the selected XYZ-Name (below)<BR><BR>
<INPUT TYPE=radio NAME=sf VALUE="" CHECKED> No!<BR>
<INPUT TYPE=radio NAME=sf VALUE=XYZ_ID> Yes!<BR>

<SELECT NAME=se>
<OPTION VALUE=""> All XYZ
[loop search="fi=XYZ/ra=yes"]
[seti XYZloop][loop-data XYZ name][/seti]
<OPTION VALUE="[loop-code]"> [scratch XYZloop]
[/loop]
</SELECT>
</FORM>
-------snipp---------

I´m able to find all items with any keywords.
But I want to find the keywords "jojo" or "Joachim".
I´ve tried with the last part of the above codes.
If I´m searching for "T-Shirt" and the radio tag is set per default, I
get the right list of items.
If I´m searching for "T-Shirt" _and_ the radio tag is set to XYZ_ID and
I choose "jojo", I get to kind of resulst:

(depends how I set the "os")
I get all items with the keywords "T-Shirt" _AND_ all items from "jojo"

For example:

1. T-Shirt    jojo  $123
2. PC         jojo  $999
3. Beer       jojo  $2
4. T-Shirt A  jojo  $234

or I get

No match for "T-Shirt | 1"

How can I do to get

1. T-Shirt    jojo  $123
2. T-Shirt A  jojo  $234

only?

I´use MySQL and MV4.04!

Any hints, helps and suggestions are very welcome!

Thanks!

Joachim

-- 
Hans-Joachim Leidinger
buch online                 jojo@buchonline.net
Munscheidstr. 14            FAX: +49 209 1671449
45886 Gelsenkirchen         FAX: 0209 1671449

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list