Originally Posted by J.M

Hi There,
I have had a look on the internet but not really been able to find the correct thing i'm looking for very easily, or at least not very well/easily explained.

I am trying to create a Search Form for my website which has 2 fields.

1) A Postcode Field.
and 2) a Category drop down Menu

When the user clicks search the search should enter a MYSQL table on my database and find the postcode entered and the selected category fields and display the results along with additonal information such as address and telephone number.

For instance.
I search L21 2AG
and pick the Category: Cafe

The search then brings up 3 results (for example)

1) LS1 2AG - Cafe - 12 Main Street, Leeds - 01313135432
2) LS1 2AG - Cafe - 16 The Green, Leeds - 01313352124
3) LS1 2AG - Cafe - 90 Grove Street, Leeds - 013131242342

Anyone got any idea's.
Any code I can use, and websites for tutorials or something maybe.
I have a basic idea of the code Im going to require, not not very detailied idea.

Thankyou very much, I do hope you can help me.
Also I hope this was posted in the correct post, I've used this website numerous times before but only just created an account and posted.

Cheers,
Jordan


EDIT: Also I understand I may need a search.php file to proccess this? Cheers

Originally Posted by kekkaishi

ok, lets say u name search field 'search' and the drop-down menu for 'cat'. and make the form POST all info to search.php (method POST action search.php).
In the search.php, the first thing u need to do is to retrieve the posted info.
for example,

Help with Code Tags

PHP Syntax (Toggle Plain Text)

$postCode = $_POST['search'];
$cat = $_POST['cat'];

$postCode = $_POST['search']; $cat = $_POST['cat'];

Having done that, u need to query the database. you may want to SELECT all from your postcodestable WHERE postCode = $postCode AND category = $cat and display all info.
If you don't know how to do this, I suggest you to take this tutorial at http://www.tizag.com/mysqlTutorial/mysqlquery.php. Have a skim thru all the links.