Hello
I have 2 queries I would like to execute it every 30min but I don't know how to add it to cronjob
can any one assist me ? please attach he php file that I need to upload to cron directory
queries are :
PHP Code:
update user JOIN userfield ON user.userid = userfield.userid set user.usergroupid = 2 WHERE user.usergroupid = 4 and userfield.field14 = 'female'
update user JOIN userfield ON user.userid = userfield.userid set user.usergroupid = 16 WHERE user.usergroupid = 4 and userfield.field14 = 'male'
thank you