RE: [mv] Using MiniVend as a catalog of businesses and SQL Config

[Barney Treadway <barney@wttech.com>]

******    message to minivend-users from Barney Treadway <barney@wttech.com>     ******

Hi Roger,

Oh my, I get to answer a question rather than plead for help! Too bad the
answer will probably be wrong.

The site I'm building has a list of members of which I use Minivend to
present and search. I decided NOT to use the productsdb at all but use a new
mysql db called clients. This is possibly more in depth than you care but as
a newbie, I love getting details so here they are. merchantcat is the
category, merchanturl is their website,and comment is a place where they can
describe their business, rest should be intuitive. The Mysql table is
configured thusly: (yeah I suppose username should be unique too, hmmmm)
________

CREATE TABLE clients (
   id mediumint(9) DEFAULT '0' NOT NULL auto_increment,
   accounttype varchar(128),
   merchant varchar(128),
   merchantcat varchar(128),
   merchanturl varchar(128),
   logo varchar(128),
   address1 varchar(128),
   address2 varchar(128),
   city varchar(128),
   state varchar(128),
   country varchar(128),
   zip varchar(128),
   phone varchar(128),
   fax varchar(128),
   tollfree varchar(128),
   contact varchar(128),
   contactemail varchar(128),
   comment longtext,
   username tinytext NOT NULL,
   password tinytext NOT NULL,
   UNIQUE id (id),
   KEY id_2 (id)
);

_____________

Then my catalog.cfg file has this line:
Database            clients      clients.asc
dbi:mysql:databasename:localhost:3306
also:
Database            clients DELIMITER    TAB
Database            clients LongReadLen  128
(which I don't have any idea what it does)
and finally:
# Not needed unless your database requires a login
Database            products USER   username
Database            products PASS   mypassword
______________

Then I can hit the db with links like this:
<A HREF="[area scan
fi=clients
se=accommodation
ml=6
st=sql
sp=members
sf=merchantcat]"><B>Accomodations</B></A>
to list all merchants with merchantcat of accomodation and display using a
special members results page. This page shows merchants with link and
comment like so:
inside my [search list] doodad.....
 <TD VALIGN="top" COLSPAN="2"><FONT SIZE="3">
  Website: <A HREF="[item-data clients merchanturl]">[item-data clients
merchanturl]</A></TD>
<tr><tr>
<TD VALIGN="top" COLSPAN="2">
Email: <a href="mailto:[item-data clients contactemail]">
[item-data clients contactemail]</a></TD>
</TR><TR>
<td><FONT SIZE="2">phone: [item-data clients phone]</font></td>
<td><FONT SIZE="2">fax: [item-data clients fax]</font></td>
</TR><TR>
<td colspan=2><FONT SIZE="2">[item-data clients address1]</font></td>
</TR><TR>
<td colspan="2">[item-data clients city], [item-data clients state]
[item-data clients zip]</td>
</TR><TR>
<TD COLSPAN="2"><hr>
 [item-data clients comment]
 </TD>
etc etc....
________________

Hope this helps........

Barney Treadway
WT Technologies
barney@wttech.com

-
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