categories how to get data

[yobo]

hey all,

 

i am building a webiste at the moment, and i am having problems making the categories for example i will have links called admin hacks, avatar hacks, user panel hacks etc....

 

now i have done the database and i have 3 tables

1) to store members

2) to store hacks

3) to store the categories

 

when a user submits a hack using my form, they have to select the category from a drop down list that there hack belongs to, when they submit the form the information will go into the hacks table along with the id(typeid) of the chossen category (typeid appears in the category table and hacks table)

 

now when lets say a user wants to view all the hacks that are assiocated with the admin category (this category typeid is 1)

 

how do i make it so that all the hacks that releat to this category are pulled down into the page and so on for the rest of the categories