Plugin for top search?

[MagicV]

Hi Folks!

I'm looking for a Plugin that can show the top search-strings of the actual month. Has anybody an idea?

[garvinhicking]

Hi!

Do you mean the google_last_query sidebar plugin?

Regards,
Garvin

[MagicV]

No, because this will only show the LAST search. ordered by date/time.
I want to show which search-string is typed most (e.g. with the number of searches that linked to the blog).

Du U understand what EI mean ? *fg*

[garvinhicking]

Hi!

Yeah, but that plugin could then be used as a foundation for patching

Regards,
Garvin

[MagicV]

you are kidding me, and EI will be unhappy i spend 3 evenings with this boring plugin, and i don't understand where to jump into the code, thare are 2 possible code-points i wil see

1. generate_content_by_referrers_table
or
2. generate_content_by_vistors_table

which line is the right one?

A bigger problem is the select statement.
first i have to check wich year/month we have actually, then i have to select the correct data form my db, but the select "...where 'day' like '2008-08-%' will bring an empty answer from DB???

Whats wrong...???

When I found a way to select the data, then I will learn *fg* how to generate the right search-string in php, because i don't really know, how to generate the "2008-01-%" or "2008-03-%" to make the selct for the actual month of the year...


I guess, my sql-knowledge is poor, [/code]

[garvinhicking]

Hi!

You're already on to it, just experment some more. After Easter I can tell you more if you haven't achieved it by then

select the correct data form my db, but the select "...where 'day' like '2008-08-%' will bring an empty answer from DB???

That should work. Execute your SQL query in phpMyAdmin and see if it works. You are not allowed to put quotes around "day", you do know that?

Regards,
Garvin