Array question

[jstraa]

Hi,

I'm logging search strings in a txt file and put them in a db
once an hour. The file looks like;

search
hello
searching
search
hello

I split all lines in an array and then I want to get an array that
looks like

$array { "search", "2"
"hello", "2"
"searching", "1"}

The number is the number of occurences, can anyone help?

Kind regards,

Jeroen

[jpmoriarty]

the only way i can think of would be to put the search strings into a database instead - that will allow you to easily "group" the results.

Alternatively, if you put them into an array you could (in theory I guess, though it's going about it a rather bizarre way) read in the first value, then loop through all the others to see if they're the same - if they are, then increase the counter. Then more on to the next, loop through them all to see if they're the same etc etc. But you'd be better off letting the database do it for you if that's at all possible

[jstraa]

Hi John, thanks for your reply, but that is the problem, I want to
update once an hour to limit the load on the database server 😉

Thanks