Database Results On Page

Hello all,

I currently have an inventory system on database and my customers can access this by clicking a link on the homepage, which in turn, pops up a search form and results table. When they enter the item number it returns the qty. available, without a problem.

The problem I am having is this; I would like to have the search form on the same page they are looking at (no pop-ups). I figure the inventory system will get used more often this way. BUT when I went ahead and tried to put the search form on the page it seemed to work out ok, except that when you click submit (to start the query) it sends me to my 404 page.

When the search form was a pop-up, it just returned the results to the same page. Is there any way that I can get the search form on the same page they would be looking at, to avoid any further windows for them to open and close??

Also, to advance this a bit, is there any way that I can have the database results posted to the page without a search form? Just posted based on the item number in the URL??

Thank you for all the help, I did a search in the forum and wasn't able to find enough information to get the job done. Hope you can help.