quick mySql query help

A

Anonymous

Guest
Hi there.

I am trying to make a search page.

The user can enter search criteria such as customer first_name, surname, address etc.

How can i query this in the database?

e.g. select * customer WHERE first_name = '$name' or surname = '$surname';

Does what i am trying to do make sense??

I just want the user to be able to search using any criteria.

Any help
 
Hi K4pil,

I think you must use like operator instead of = operator.

select * customer WHERE first_name like '%$name%' or surname = '%$surname%'
 
You must log in or register to reply here.
Back
Top