Page 1 of 1

[SOLVED]How to make statistics about KEYWORD searches

Posted: Sun Jan 25, 2004 3:14 am
by Calimero
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 :D

Posted: Sun Jan 25, 2004 8:49 am
by Gen-ik
:: [php_man]explode[/php_man]
:: [php_man]mysql_connect[/php_man]
:: [php_man]mysql_select_db[/php_man]
:: [php_man]mysql_query[/php_man]
:: [php_man]mysql_fetch_array[/php_man]
:: [php_man]mysql_close[/php_man]

Check out those manual links to get you started.