[SOLVED]How to make statistics about KEYWORD searches

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
Calimero
Forum Contributor
Posts: 310
Joined: Thu Jan 22, 2004 6:54 pm
Location: Milky Way

[SOLVED]How to make statistics about KEYWORD searches

Post 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
Last edited by Calimero on Mon Jan 26, 2004 2:34 am, edited 1 time in total.
Gen-ik
DevNet Resident
Posts: 1059
Joined: Mon Aug 12, 2002 7:08 pm
Location: London. UK.

Post 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.
Post Reply