Databases

In this article I will show you how you can use the database library from eZ publish to build database independent fulltext search engine. I will show you a relatively simple algorithm to get search result ranking and stop words. You will get the full source code for a complete working program to get you started.

If you have had problems with MySQL not supporting functionality like sub-selects this short article might be of interest for you. This article will explain how to use temporary tables with MySQL

One thing you often get with a PHP Project is a big SQL file with a lot of inserts and create statements. Nothing wrong with that. But often people use the ID from an earlier insert directly in another statement. Nothing wrong with that except that readability sinks to zero, especially for someone trying to figure out what is going on.