How to automatic execute job for query?

[toplisek]

I have query like:
SELECT userid, usernamejoindate, lastactivity
FROM user
AND joindate <1298937600
AND lastactivity - joindate < 181440

How to execute each 30 days?

[penders]

If you need to automatically execute this job/script every 30 days then you could set up a CRON job on your server that will run every 30 days.

(Although I suspect you are asking another question?!)

[toplisek]

Should be CRON job inside PHP file with access to database or it can be just query.

[coopster]

You can run any command you want, including a call to a PHP script or a mysql command line query. You can also code multiple commands into a shell script and run that ... all kinds of options.