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