how to include search in my website

[mehrantahir]

Hi everyone,
First time i am going to work on the search.please help me how i make search in my site,the website is about the products,i want the user search for the products by city name,
Requirements
The simple search give result of the products in the selected city,the user is authories to select a city from the given list,if he select a city from the dropdown,
then how can i bring the search result from the whole city products,
sorry in advance if any confusion i will give more details

[Robert1995]

http://www.w3schools.com/sql/sql_where.asp

$sql = 'SELECT * FROM Products
WHERE City = '.$city;

$city is the dropdown thing .

If you want a search by product name or description .

http://www.w3schools.com/sql/sql_like.asp

[mehrantahir]

is it possible to get products from outside,not present in my databse

[almostbob]

"products" what products, needs a little more thought, otherwise its a google search
loc city: EVERYTHING

[rayidi]

General Search : mysql_query("SELECT * FROM `products` WHERE `city` = '$city'");
Just Like That Search : mysql_query("SELECT * FROM `products` WHERE `city` LIKE '$city'");