same record diff catagories problem
Posted 06 August 2003 - 12:19 PM
i have a database of news stories about my company. i want to put the stories into catagories so a user can click a button and get stories related to say, products.
some stories go in more than one catagory so for normalization i have three tables.
1. the text of the story
2. a list of possible catagories
3. a reference linking the story to the catagory
this works fine but i also want users to be able to search for two catagories at once ie. products and web design. if a story is in both these catagories it gets returned twice as the sql finds a reference linking it to one catagory then a reference linking it to the other.
I can sort it out so both aren\'t printed on the page but it messes up my number of items found and hence my pagination.
is there a better way of setting up my db or any sql that can sort this , or do i have to code around it?
Posted 06 August 2003 - 03:58 PM
SELECT distinct news_id from tables
distinct will give you only 1 result for each one.
Posted 07 August 2003 - 01:55 AM
DylanBlitz you are a fine human being.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users