Consolidating Values

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • yasmine
    New Member
    • Feb 2008
    • 64

    Consolidating Values

    Hi friends,
    How can i consolidate the values of a table which occurs mostly?
    what i'm asking is
    consider a database which contains many tables. Each table has a field namely contents. The value of it may be repeated or not within a single table.
    what i need is how can i consolidate some of the values of contents field which occurs commonly in all or more tables?

    Please help me out...

    Thanx n regards
    yas
  • TheServant
    Recognized Expert Top Contributor
    • Feb 2008
    • 1168

    #2
    Not entirely sure with what you're asking...

    Do you want to select a word or value that occurs a specific number of times in a table?

    Comment

    • yasmine
      New Member
      • Feb 2008
      • 64

      #3
      Originally posted by TheServant
      Not entirely sure with what you're asking...

      Do you want to select a word or value that occurs a specific number of times in a table?
      Hi
      What i'm asking is,
      consider a database which contains so many tables like course, questionnaire,e tc.

      One of the table having a field about feedback_catego ries such as faculty effectiveness, course effectiveness, course structure, duration, etc.
      For each of the course the feedback_catego ries may or may not differs.
      Consider the feedback_catego ries fiels contains 100's of values that may or may not repeated.
      Now how can i consolidate the feedback_catego ries, in the sense the values which occurs maximum numbers?
      I have to write a php script that should consolidate dynamically all the common values.

      I extract all the unique values in feedback_catego ries and fetch it in an array.
      But I don't know how to match those values to find out which are the common values that occurs most of the time....

      Please help me out........

      Thanx n regards
      Yas

      Comment

      Working...