Hi;
I am making a database driven webpage, and I want to show the data of database by category as well, by pooling down a menu and choose your category, a page of data of the matching category show up in a page,
I have made my database and totally have 8 tables in my database:
Name, company, tel_no, fax_no, Address, webpage, email, category,
Tables have relationship with the Company table except category, because I don’t know how this category table should be related to what,

These are the columns on the tables:
Name_Id, Name, company_ID
Company_ID, company
Tel_Id, tel, company_Id
Fax_Id, fax, company_Id
Address_Id, address, company_Id
Webpage_id, webpage, company_Id
Email_id, email, company_Id
Category_Id, category

And the category can have some values like:
Computer, Printing, auto, etc..


I have made the database using MS access 2000, and converted it to Mysql, because I intend to use PHP and Mysql, with DWMX,
I have made a simple database driven webpage with PHP and mYsql, and it worked now I want to make this webpage with a ability of search and inserting data and having a category function, so now can not make the category thing,

How this can be done?
How do I relate the category to other tables?
How to do it on DWMX?

Any reply is appreciated about this category feature>

Thanx.