blog.dev001.net

If you need a HTML list with the markers (dots, squares, list-style-images, whatever you use) on the right side (for instance for a navigation menu that is aligned to a line on its right side), you can achieve this by using RTL (right-to-left) text:

• aligned to the right side
• yes, it is

Demo:

• aligned to the right side
• yes, it is

In “1/3 Implementing an AutoSuggest feature using MySQL fulltext indices” I described how you can use a MyISAM full-text index to extract search words for an AutoSuggest feature. Then, in “2/3 myisam_suggest: an AutoComplete tool for MySQL fulltext indices” I wrote how to install and use myisam_suggest to extract these search words in practice.

Here you will find how to use AJAX AutoSuggest together with my tool “myisam_suggest”.
For a demo, see www.gimpusers.com. Enter some characters (e.g. “brus”) into the search field on the top of the page.
Continue Reading

As I’ve written in my previous post “1/3 Implementing an AutoSuggest feature using MySQL fulltext indices”, it’s possible to use the MySQL/MyISAM full-text index to extract search words for an AutoSuggest feature with great performance (because the index tree is used actually). This tool, called myisam_suggest, is my first implementation of this.
Continue Reading

The MySQL full-text index

Current MySQL versions provide a full-text index (FTI) which is generally used to index and search MyISAM (the default storage engine in MySQL) tables like this:

SELECT id, content FROM documents WHERE MATCH(content) AGAINST (“tes*” IN BOOLEAN MODE)

Internally, every indexed (text) column of a row is splitted into its words. Continue Reading