Meta Keyword Generator

[phpmine]

Hello you fellow PHP Builders! I am looking to make an automatic meta keyword generator based on an array of phrases. It is more my site that is under construction, http://www.phpmine.com. Go to the "Q and A" section and you'll see a series of questions there, five in total. right now the system simply grabs all the words there, filters though common words, and then spits out the words as keywords. I would like some advice on how to set it up in this way:

• puts all the words in an array and counts their frequency

• creates an array of two words phrases and counts their frequency

• does the same for 3 word phrases

• spits out the top 25 keywords from the array generated

maybe someone has already cooked up this nasty script. thanks in advance guys!

[bpat1434]

1.) Are you storing the "keywords" in a database or some other form?

If you are storing them in a database (which you probably should be) then it's just a matter of doing an easy "COUNT(*) FROM table WHERE ? GROUP BY question_id"

Now the "?" in the WHERE clause would be what you limit it to. Since you're searching the keywords, you can easily say:

COUNT(*) AS `cnt`
FROM `table`
WHERE `keyword` = '$something'
GROUP BY `question_id`
ORDER BY `cnt` DESC

Or for two-word phrases:

COUNT(*) AS `cnt`
FROM `table`
WHERE `keyword` = '$something $something2'
GROUP BY `question_id`
ORDER BY `cnt` DESC

And for three-word phrases:

COUNT(*) AS `cnt`
FROM `table`
WHERE `keyword` = '$something $something2 $something3'
GROUP BY `question_id`
ORDER BY `cnt` DESC

Then you can take all those results, and they'll be in most-popular to least-popular order. Then you can pick and choose which results you want to show. Or you can merge all 3 of them into one array and sort them. You'd want to watch out for duplicates that actually overwrite some other phrases (like if you had 2 phrases that equally scored a 25). So you might have to do a little bit of manual labor to get it working correctly.