Google trends php script

google trends php script to monitor keywords trends

[radiofanatic]

Hello everybody,
I have a small php script which extracts every hour the google hotest trends and insert them into a mysql database.
I would like to know how to create a php script which will:
1 - show hotest trends on certain period
2 - show keywords which have a growing trend on certain period.

Thank you very much.

[edited by: jatar_k at 8:06 pm (utc) on June 25, 2009]
[edit reason] no urls thanks [/edit]

[jatar_k]

Welcome to WebmasterWorld radiofanatic,

as long as you are storing a datetime, a way of identifying each link/site uniquely and the positions or whatever else the tracked data is then you just need to play with grouping and counting in your queries.

You mght want to look at some graphing software as that might help you do what you need.