Filter database record as you type in real time and show output on page

Hello

I have created one page where I need to filter the record in real time, e.g when the user start typing the search keyword on the filter box. Here I have created two recordset with the same name with else statement and when no query by default then default query loads with full data and when I do the search then the result query loaded. The results are showing correctly without any problem.

Now I am stuck in two position;

1. I need to make search in real time that means I should not hit search button to filter the query rather when I start typing then the filtering should start base on my input keys matching which is not happening now.

2. When I back press from the keyboard or empty the query field then the default query should load automatically but which is not happening now and I need to refresh manually the whole page to load the default query.

** This is likely same as your forum search system only difference is that when query field is empty then all the default record should load instead of empty page.

Pls help me on this subject. Thanks in advance.

I am attaching herewith the ftp access info.