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.
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.