Run SQL Query

[Quiver]

Could someone please tell me how to do this:
http://xenforo.com/community/threads/query-help.31374/#post-358874

But from a XenForo addon (obviously we're talking PHP files here).
The above code works fine in phpMyAdmin. But I'm looking, ideally, to create a cron job that runs once an hour and finds the top poster in that last hour using UNIX_TIMESTAMP or whatever it is that you use to limit searches based on time. Yes, I have no clue how to do what I'm trying to do, but I have a very good idea what I want the end result to be.

Please could someone help me do this in stages.
STAGE ONE. Make a PHP file to display the top poster based on a preset time (forget the hourly function for now...say...midnight on whatever day, just make up a date I don't care what it is. LOL!)

A heads up, I've read this file (both the 1st and the 2nd page).
The code give there is partial code. I have no idea what to do with it.
I'm a Windows developer and I'm familiar with C++ and C# but when it comes to working with PHP I am totally confused. It's like a completely different language to me. http://xenforo.com/community/threads/mysql-queries-how-to-use-db-in-xenforo-small-notes.5444/page-2

 

[borbole]

The code give there is partial code. I have no idea what to do with it.
I'm a Windows developer and I'm familiar with C++ and C# but when it comes to working with PHP I am totally confused. It's like a completely different language to me.

In that case, imho, it would be better if you posted a request at the request section for someone to code that for you.