how to create a query that allows country or product search

[fireslug]

On *******.com, a user can search for products in a search box, and by category or country, in drop down boxes.

Can anyone help by telling/showing me how to set up the database tables so that I can install the same methods please?

[fireslug]

Mmm i didnt know that site names would not appear. The name of the site that allows the search that I would like to replicate, is ******* dot com

[dagon]

rather vague, what do you have now? if nothing, start with some basic tutorials on php and mysql.

[fireslug]

Sorry, i was short on details. I'm a real greenhorn at this stuff, an have no idea how to get things going

It took a number of attempts to install WAMP on my pc, but i got it going, and want to have a go at creating the tables that i need so that eventually i can finish my site without the help of a coder. I dont have the funds to pay another coder, so i want to give it a go on my own.

My site was built by an indian coder, but it did not work properly, so all the online php pages were deleted, along with the database. But i retained copies of the php pages on my pc

I want to try and create the database on my pc so that i can learn how to write the code to display the relevant queries that visitors will want to see.

I installed EASYPHP in the program files folder, and copied the existing php files from my working drive E, into the www folder of EASYPHP.

I can access phpmyadmin, and want to create a database so that it can be searchable by product, suburb, store, country and town.

I dont have any tables in the database as yet. I want to create the following tables: specials, classifieds, hot products, all searchable by product, suburb, store, or country, like they can be in the ali baba site

I you can offer any help, it will be greatly appreciated.