Requery on text field change
I have some text fields on my page. I would like to requery my database columns as the user enters text into these fields (each field being for a different column). It would need to filter the records with each keystroke and if the user enters into more than one column it needs to filter based on all of the fields that have text in them.
I know that I probably need to create a function that will be called on the onChange event for each text field and store the value in a variable but I can't figure out how to get the query to fire each time the function is called.
Is PHP the best way to do this or can anyone offer some better alternatives? I appreciate any help.
Thanks in advance.