Hi,
I have created a search form with three fields including the primary key, to search a database with thirty fields. It is connected to a results page that has three fields. When I test the search page it returns the record. But when I use it online the results page is empty. What can I do.

Dreamweaver 8
PHPMySql

can you give us the link to test it?

There are two instances.
1. Go to www.kloco.net/project.html >click on Social Service - log in with username guest password guest.
2. Go to Update Record and the test name is John Doe SS# 043465678 This should bring you to /ispphp/ResultPage.php and click on the social security number Which should bring you to /ispphp/update.php.
3. Go to Review same test name and 3. This should bring you to /ispphp/ReviewResultPage.php and click on the social security number Which should bring you to /ispphp /client_record.php.

You're right. The search tool doesn't show any results even though the record exists. I would suggest to make your search form have one search option at first, to test and see if the result comes up.


Waht does your Query looks like?

I was able to correct the problem. I mis-labeled the text boxes. Thanks for your help.