Listing all articles in a category

[BigDen13]

Table Structure:

Table
article
articlecategory
author
category

The category table lists the main categories while the articlecategory table is a join that lists the

category id and the article id.

On my main page I have all articles listed. However, I would like other pages to contain only stories

from category x, y etc.

I run the query:

$query = 'SELECT * FROM articlecategory WHERE categoryid=3';

but it returns nothing.

[codeexploiter]

Can you please provide the structure of your tables. I don't think the table names you mentioned in the posting does not server their purpose as they supposed.