# PHP search MySQL

**URL:** <https://forum.kirupa.com/t/php-search-mysql/136468>\
**Category:** Uncategorized\
**Created:** [February 5, 2005, 5:08am UTC](https://forum.kirupa.com/t/php-search-mysql/136468 "2005-02-05T05:08:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![thebloodpoolkid](https://avatars.discourse-cdn.com/v4/letter/t/ecb155/32.png) [@thebloodpoolkid](https://forum.kirupa.com/u/thebloodpoolkid)\
**Post date:** [February 5, 2005, 5:08am UTC](https://forum.kirupa.com/t/php-search-mysql/136468/1 "2005-02-05T05:08:29Z")

</div>

I have made a form that collects user information and inserts it into a MySQL table.

---- Haunts\_submit.php

I have a page that displays these records. Repeat region and recordset paging.  
---- Haunts\_wny.php

What I want is to have a 3rd page that will allow users to search via two fields.  
Haunt Type – List Menu  
City – Text Field

Haunt Type and City are fields of the table.  
For instance. If I went to the site and clicked on “Find a Haunt” and I select ‘Home Haunt’ from the list, I would like the results of all matching home haunt records to be displayed on the following page.

I have a structure worked out.  
Haunt\_find.php —\> Haunt\_find\_processor.php—\>Haunt\_results.php

Anyone have a hint of how I can accomplish this? Tutorials or script snippets. I am still a beginner. I searched the forum but have not found full answers unless I am just ignorant to the fact.