Thanks Kim and Georg, but I want to do this myself! Ok it may be hard, but i'm confident.... I have taught myself an awful lot by having a 'difficult' project on the go
so, bearing that in mind, can I re-ask my question! thanks again incidently I am making a SITE search, not a web search engine Jules > > > Hi everyone, > > > > I want to build a MySQL site search. Can anyone help with my 'overview' > > > > I have written a perl programme to open each html file, cut out all the tags > > and create a hash of hashes each word is a key, then the secondary key is > > the filename, then the value is the number of occurances in that document. > > > > So how should I make my SQL tables? I thought a 2 column > > (filename:occurances) table for each word would be the best way, but thats A > > LOT of tables. I'd get perl to do all the writing, and I'm sure I could get > > it to work this way. > > > > But is this the best way? I'm fairly new to MySQL so please be explicit! > > > > thanks for your time > > > > Jules > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
