[SOLVED]How to make statistics about KEYWORD searches
Posted: Sun Jan 25, 2004 3:14 am
In a textfield in a form keywords are entered,
so what I need help with:
1) How to separate word by word from the textfield (from all the words entered by someone)
2) Then how o count them, add them a time (when the query was submited), For each word check if its new and enter a new record, or if it is repeated add it and increase the frequency no. - in that column
3) I will use MySQL and store the results in there - all of this in 1 table
id, keyword, frequency, time_submited
Thanks ahead, I would like to promise a reward, but I'm just starting to build this thing soo... maybe in future
so what I need help with:
1) How to separate word by word from the textfield (from all the words entered by someone)
2) Then how o count them, add them a time (when the query was submited), For each word check if its new and enter a new record, or if it is repeated add it and increase the frequency no. - in that column
3) I will use MySQL and store the results in there - all of this in 1 table
id, keyword, frequency, time_submited
Thanks ahead, I would like to promise a reward, but I'm just starting to build this thing soo... maybe in future