Jump to content


Photo

same record diff catagories problem


  • Please log in to reply
2 replies to this topic

#1 dan_small

dan_small
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 06 August 2003 - 12:19 PM

hi there,

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?

#2 DylanBlitz

DylanBlitz
  • Members
  • PipPipPip
  • Advanced Member
  • 99 posts
  • LocationOC Baby!

Posted 06 August 2003 - 03:58 PM

you should be able to keep it that way, just when you do your select do something like:
SELECT distinct news_id from tables

distinct will give you only 1 result for each one.

#3 dan_small

dan_small
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 07 August 2003 - 01:55 AM

You see i knew there would be something like that!

DylanBlitz you are a fine human being.

Thankyou




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users