Member Avatar for 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.

  • 2 Contributors
  • 1 Reply
  • 78 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by Puckdropper
Member Avatar for Puckdropper

Are you sure something exists at categoryid=3? Does a

select *

return any results?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.