Hello; I've got a long list of words and their descriptions stored in a mysql table. The user interface is provided with a list that I made using html option. Now, what I want to do is to enable users to quickly reach the word they are looking up by typing the first few letters so that the options will appear as a list below the typing box; and I want only the words in the database to be seen, not irrelevant words. Is there a mysql / php command, script to achieve that? I tried LIKE but it didn't work at all. Can anybody help? Thanks in advance.
Thank you very much. I somehow managed to get what I wanted. The list appears just below the type box when letters are typed. However, I couldn't find an answer to how to autosubmit the form. There are answers but none meet my need. Some autosubmit at the end of a predefined period, which is either too quick or too slow. I tried onchange and the form was submitted but without the input.