Re: [htdig] indexing mySQL table


Subject: Re: [htdig] indexing mySQL table
From: Zon Hisham Bin Zainal Abidin (zon@mad.scientist.com)
Date: Thu Dec 14 2000 - 03:23:45 PST


Geoff Hutchison wrote:
(..snip..)

> So if you have, for example, a web frontend to your mySQL
> database (e.g. a PHP-generated set of pages or whatnot), then you
> just set ht://Dig to index the frontend.
>

YES. It will definitely work...But ..
NO. That is NOT what MOST ppl want :(

My frontend looks like this:
http://domain/result.php?cat=AUT&subcat=AUT-CAR


1)htdig will index: http://domain/result.php?cat=AUT&subcat=AUT-CAR
                    http://domain/result.php?cat=AUT&subcat=AUT-BIKE
                    etc etc

2)result.php looks inside my content table AND then refer to (lookup) to
table category and subcategory for the appropriate codes (eg AUT stands
for automobiles, AUT-CAR stands for car).

Now, visitors will NOT be able to search for 'Automobile' or 'Bicycle'
bcos these words were not indexed ! They can however (I think), search
for AUT-CAR, which is NOT what we want.

Therefore I need to somehow tell htdig that those 3 (content,cat and
subcat) mySQL tables are related and do index them together.

Please help.

------------------------------------
To unsubscribe from the htdig mailing list, send a message to
htdig-unsubscribe@htdig.org
You will receive a message to confirm this.
List archives: <http://www.htdig.org/mail/menu.html>
FAQ: <http://www.htdig.org/FAQ.html>



This archive was generated by hypermail 2b28 : Fri Dec 15 2000 - 10:11:20 PST