Order Search

[Guest]

I'm trying to create a php page with a search box and a drop down box to search through customers/orders.

 

Example:

 

Type in search box 'bloggs' and select 'Last Name' to search for anyone with that surname.

 

I also want this search and drop box o be able to handle the following:

 

First Name

Last Name

Company Name

Billing Post Code

Shipping Post Code

Item Purchased

 

Is there a quick way of doing this or maybe something already in circulation (can't find anything in he contributions/forum)

 

I hope that someone can help me with this - it would save me on average 30minutes a day trying to find certain customers records when they supply limited information (usually on the telephone).

 

Thanks, in advance