database structure

[Anon]

I am building a website with articles on it using php and a mySQL database. The articles are sorted in categories, I have one table with the articles in it and another tables with the categories.
It should be possible for one article to be in more than one category without copying the article.
The question is, whats the best way to link the article to the categories its in? It should be easy to list all the articles in a category and also to edit the list of categories a certain article is in.
Maybe its a dumb question but i'm new to php/mysql and i dont know all the possibilities yet 🙂

[zhabala]

Usualy it is done by third table, for example. You can have tables:

create table article ( art_id int, name char(50));

create table category ( cat_id int, name char(100));

and then third table:

create table art_cat (
ac_id int,
art_id int,
cat_id int )

It allows you to have one article in many categories.

[Anon]

Thanks, thats what i was thinking about 🙂