Zh Google Map

Hi Dima, how are your?
Man, i badly need your help.
Could you help me about the formula to set for cron?
I just want to set a command where entry is automatically deleted if older than 1hr
Thanks in advance

Marv

Just little search:

stackoverflow.com/questions/12131947/del...om-mysql-after-24hrs

www.w3schools.com/php/php_mysql_delete.asp

You can create CRON job with PHP file (which connect to database and delete data which is "old")
Or create EVENT in MySQL

Is it as simple as this? :blink:

DELETE FROM com_zhgooglemap WHERE `time` < NOW() - interval 1 HOUR

Or this on:

USE Database_name;
DELETE FROM Table_name
WHERE Date_column < DATEADD(mi,-15,GETDATE())

MarvinG wrote: Is it as simple as this? :blink:

DELETE FROM com_zhgooglemap WHERE `time` < NOW() - interval 1 HOUR

just replace #_ to your real table prefix

it deletes previous day placemarks

Yes, it is very easy

#__zhgooglemaps_markers - table, where I store placemark information
createddate - date and time of placemark creation

Dima, i don't know whether i have it right, i try to set this in phpmyadmin as an event.

The command line you give me above, its for sql isn't it? So where to run it? I'm really null at sql & cron

i put: DELETE FROM f58dq_zhgooglemaps_markers WHERE createddate < NOW() - UNIX_TIMESTAMP(createddate) > 60

It is not accepting it.
---
If i creat a php file with the command and point cron to it, where should the php file be stored?