Sam,
I’ve taken a look and experimented by incorporating the limit( ) function in my code. As you say, and as the documentation indicates, it limits the number of returned items correctly to the value set in the parentheses. However, it also seems to limit the number of entries searched in the database table to the same number. I.e. If your database has 100 entries and you set the value to 10, it only searches the first 10 entries in the table and matches them as applicable, but it ignores the other 90 entries!
For two of the three databases I am working on, setting the limit to 1000 would work, as they currently have only around 250 and 600 records respectively. However, my largest database has over 1000 records, so searching the complete database is not possible. I would also like to search the entire database, but limit returned matches as per the intention of the limit( ) function.
Your thoughts on this would be much appreciated.
Rod