Hi all,

I've been hacking the Glossary/Glossaire module. As it stands right now, I've added an extra row in the table for 'related terms'. When an entry is displayed, these related terms are automatically hyperlinked (as a search term).

However, what I'd like to do is this: rather than add related terms for each entry, I want to automatically link up words within a definition if they already exist in the database. So if my database has 100 terms in it, and 6 of these words are found in the definition the person is currently viewing, each of the 6 will be hyperlinked.

Here's the code I have for my 'related terms' hack ($glo_related are the related terms stored in the db, separated by commas):


Any ideas on how this can be modified to do what I want it to? The terms are listed in the 'nom' row in the db.

Thanks for any assistance!


Brad

Well I still haven't had much luck with this... are there any good MySql tutorial sites out there? Basically I have to figure out a way to build a list of all the terms currently in the database, then search through the current definition for all the words in the list, and replace them with links to the terms themselves... It sounds relatively easy to do, I'm just stumbling with the code right now.


Brad

Any ideas for this? I'm going to attempt to come up with something this weekend, and I'm not sure if there is enough beer and/or coffee in my apartment to stem my "creativity" for this one!


Brad