PDA

View Full Version : Listing all articles in a category



BigDen13
12-11-2006, 07:58 AM
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
12-11-2006, 11:36 AM
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.