Connecting Tech Pros Worldwide Forums | Help | Site Map

Consolidating Values

Member
 
Join Date: Feb 2008
Posts: 65
#1: Mar 17 '08
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's Avatar
Expert
 
Join Date: Feb 2008
Location: Australia
Posts: 914
#2: Mar 18 '08

re: Consolidating Values


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?
Member
 
Join Date: Feb 2008
Posts: 65
#3: Mar 18 '08

re: Consolidating Values


Quote:

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

One of the table having a field about feedback_categories such as faculty effectiveness, course effectiveness, course structure, duration, etc.
For each of the course the feedback_categories may or may not differs.
Consider the feedback_categories fiels contains 100's of values that may or may not repeated.
Now how can i consolidate the feedback_categories, 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_categories 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
Reply