RE: Minivend <-> MySql problems

["Russ" <russ@khouse.org>]

Searching with mySQL and minivend is seemingly untrodden territory, seeing
as how no matter how many questions I ask about searching the mySQL
database, no one seems to have useful information.  To do what you are
saying though, I have figured out.

<form method="POST" action=[process-search]>
<input type="hidden" name="mv_searchtype" value="sql">
<select name="mv_search_field">
           <option value="author" selected>Author
           <option value="title">Title
           <option value="detail">Description
           </select>
<input type="hidden" name="mv_substring_match" value="yes">
<input type="hidden" name="mv_matchlimit" value="10">
<input type="hidden" name="mv_sort_field" value="price">
<input type="hidden" name="mv_doit" value="search">
<input type="text" name="mv_searchspec" size=20>
<input type="submit" name="mv_todo" value="Search">
</form>

This is my example.

Russ

-----Original Message-----
From: owner-minivend-users@minivend.com
[mailto:owner-minivend-users@minivend.com]On Behalf Of adfranse
Sent: Thursday, July 15, 1999 7:46 AM
To: 'minivend-users@minivend.com'
Subject: Minivend <-> MySql problems


******    message to minivend-users from adfranse <info@afa.nl>     ******

Hi,

I finally got Minivend working with a MySql Products table. I still have a
few questions though.

1. Is it possible to only use the Mysql database without the products.asc
file.

2. I want to be able to search on parts of a field eg when a user types
'ABC' I want Minivend to find 'ABC' but also 'GSFABC' and 'FEYHABCFSE'.

3 Are there any templates for using Minivend with MySql ?


I hope someone can help me with this.....


Greetings, Walter


-
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