foreign keys and search page

[gavenp]

I have a db I created in mysql using a program to convert a ms access db to mysql. The program worked fine from what I can see.

What I want to do though is to create a form that will allow me to search this db for the following

Company (one table)
position (one table linked to company)
Country (one table linked to company)

I extracted the db out of mysql using phpmyadmin.

Now I am lost as to how to create the form.
The file it created is attached however I cut some of the options out so the file would fit in this message.

Any assistance would be great.

[nemonoman]

So:
Are you trying to create a search form that searches the companies and shows results for the other tables? Or to search on any table? Or all tables? With "OR" type logic (any result displays) or "AND" type (only records that match ALL criteria?

Are you having trouble with the SQL, the HTML or the PHP??

[gavenp]

Iwould liek to create a search that llows people to search the company name, the position title or the country. They should be able to search all of these toether or any combination of them.

It is the sql query that i am having trouble with. I dont know how to write it into a php page that will do excute th query and return the results.