PHP MYSQL Search Form

[kwmlr439]

I have a website that runs on WordPress / PHP & MYSQL Database. I was hoping to build a search form that will access my database and grab result to display in a separate page.

 

 

Any help would be greatly appreciated. Thank you!

[Barand]

Do you have a question?

[kwmlr439]

Gurus,

 

My question is that i need help on how to build the tables and the php code. Here is my HTML Form:

 

<form role="search" method="post" id="searchform" action="#" >

<input type="hidden" value="" name="s" />

 

<input type="hidden" value="listing" name="post_type" />

<select name='State' id='State' class='state'>

<option value="Select a State" selected>Select a State</option>

</select><select name='county' id='county' class='county'>

<option value="Select a County">Select a County</option>

</select><select name='city' id='city' class='city'>

<option value="Select a City">Select a City</option>

</select>

<select name='company' id='company' class='company'>

<option value="Select a Company">Select a Company</option>

</select><select name='agent type' id='agent type' class='agent type'>

<option value="Agents Type">Agents Type</option>

</select>

<input type="submit" id="searchsubmit" class="searchsubmit" value="Search Real Estate Agents" />

</form>

[Barand]

We are not clairvoyant and have no idea of what data you need to store, so telling you how to design your tables is not an option. Other than to point in the direction of "data normalization".

 

We do not write your code, at least not for free. Post in our freelance forum if that is what you need