[FiRe]

Just out of interest, is there a more accurate way of searching a database than this for example:

SELECT name FROM books WHERE name LIKE '%$name%'

??
If I have the the book 'cats' and i type in 'cat' it would find it, but if I type in 'catz' it wouldnt find cats...

[dennispopel]

Hello,

While it seems less accurate to me, consider the SOUNDEX() MySQL function.