* You are viewing the archive for January, 2009

HTML/CSS lists with markers on the right side

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

3/3 Populate an AJAX AutoSuggest field on your Web site with myisam_suggest

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

2/3 myisam_suggest: an AutoComplete tool for MySQL fulltext indices

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

1/3 Implementing an AutoSuggest feature using MySQL fulltext indices

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

blog.dev001.net is Digg proof thanks to caching by WP Super Cache