Cron Jobs

[boelter]

I have created a directory website where people can submit dances and I am trying to figure out how to create a cronjob that deletes the old dances for me. The database I am using is MySql. Any help would be appreciated.

here is my table set up:
CREATE TABLE `rally_data` (
`rally_id` int(11) NOT NULL auto_increment,
`rally_name` varchar(255) NOT NULL default '',
`rally_address_1` varchar(255) NOT NULL default '',
`rally_address_2` varchar(255) NOT NULL default '',
`rally_city` varchar(255) NOT NULL default '',
`rally_state` char(2) NOT NULL default '',
`rally_zip` varchar(10) NOT NULL default '',
`rally_country` varchar(25) NOT NULL default '',
`rally_sponsor_name` varchar(255) NOT NULL default '',
`rally_sponsor_phone` varchar(25) NOT NULL default '',
`rally_sponsor_fax` varchar(25) NOT NULL default '',
`rally_sponsor_email` varchar(255) NOT NULL default '',
`rally_contact_name` varchar(255) NOT NULL default '',
`rally_contact_phone` varchar(25) NOT NULL default '',
`rally_contact_fax` varchar(25) NOT NULL default '',
`rally_contact_email` varchar(255) NOT NULL default '',
`rally_start_month` int(11) NOT NULL default '0',
`rally_start_date` int(11) NOT NULL default '0',
`rally_start_year` int(11) NOT NULL default '0',
`rally_end_month` char(2) NOT NULL default '',
`rally_end_date` int(11) NOT NULL default '0',
`rally_end_year` int(11) NOT NULL default '0',
`rally_notes` text NOT NULL,
`rally_link` varchar(255) NOT NULL default '',
`rally_weather` varchar(255) NOT NULL default '',
`rally_lodging` varchar(255) NOT NULL default '',
`rally_map` varchar(255) NOT NULL default '',
`rally_image` varchar(255) NOT NULL default '',
`view_enabled` char(1) NOT NULL default 'V',
`submitter_email` varchar(255) NOT NULL default '',
`rally_type` varchar(20) NOT NULL default '',
`rally_style` varchar(255) NOT NULL default '',
`feature` char(1) NOT NULL default '',
PRIMARY KEY (`rally_id`)
)

[felgall]

First step is to write a script that does the deleting that you want probably using Perl or PHP to call the appropriate database commands.

Second step is to test the script to make sure it works.

Third step is to set up a cron job to run the script.

[boelter]

Thanks! I have now made the cript and it works, but I am unsure how to make the cron job run the php script with cron job. Could you send me to a good tatorial?