TalkPHP
 
 
Account Login
Latest Articles
» The basic usage of PHPTAL, a XML/XHTML template library for PHP
» Vulnerable methods and the areas they are commonly trusted in.
» Simple way to protect a form from bot
» The Basics On: How Session Stealing Works
» How to keep your forms from double posting data
IRC Channel
IRC Speech Bubble Join the friendly bunch on IRC...
(#TalkPHP on Freenode)

...Also available via a web interface.

See this thread for information on the TalkPHP Free Hugs Initiative™. Subject to availability.
Associates
Associates
CSS Tutorials
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 02-04-2008, 11:28 PM   #1 (permalink)
The Contributor
Upcoming Programmer 
 
Gurnk's Avatar
 
Join Date: Oct 2007
Location: US
Posts: 66
Thanks: 19
Gurnk is on a distinguished road
Help Event Scheduler... Maybe?

Hey Guys

I have a question. If I want to run a MySQL query every 24 hours, should I use Event Scheduler. I would like to stay away from cron jobs, as I have no clue about them. Though to be fair, I've just now heard of Event Scheduler.

If you have any examples or explanations of either, it would be very helpful.

Thanks
Send a message via MSN to Gurnk
Gurnk is offline  
Reply With Quote
Old 02-04-2008, 11:32 PM   #2 (permalink)
The Addict
Upcoming Programmer Top Contributor 
 
Rendair's Avatar
 
Join Date: Nov 2007
Location: UK
Posts: 319
Thanks: 18
Rendair is on a distinguished road
Default

I have used cron jobs...with my host you just select the file you wish to run with the script and select the repeated times like if you want it every hour or every 24 hours and so on

Introducing Cron [PHP & MySQL Tutorials]
__________________
www.jooney.co.uk - the online portfolio
Send a message via MSN to Rendair
Rendair is offline  
Reply With Quote
The Following 2 Users Say Thank You to Rendair For This Useful Post:
Gurnk (02-06-2008), ReSpawN (02-14-2008)
Old 02-06-2008, 11:57 AM   #3 (permalink)
The Contributor
Upcoming Programmer 
 
Gurnk's Avatar
 
Join Date: Oct 2007
Location: US
Posts: 66
Thanks: 19
Gurnk is on a distinguished road
Default

Cool, Thanks. :) Anyone have any other suggestions?
Send a message via MSN to Gurnk
Gurnk is offline  
Reply With Quote
Old 02-14-2008, 07:18 PM   #4 (permalink)
The Wanderer
 
cherries's Avatar
 
Join Date: Oct 2007
Posts: 20
Thanks: 0
cherries is an unknown quantity at this point
Default

cron jobs is really easy to learn.
php myPHPfile.php

and set the time to every 24 hours.
cherries is offline  
Reply With Quote
Old 02-14-2008, 08:03 PM   #5 (permalink)
The Frequenter
 
ReSpawN's Avatar
 
Join Date: Nov 2007
Location: Netherlands
Posts: 460
Thanks: 49
ReSpawN is on a distinguished road
Default

I believe even DirectAdmin and Plesk (and Enzym) offer a great deal of support for this, but I have yet found time to figure it out.

Thanks @ Dale.
__________________
"Life is a bitch, take that bitch on a ride"
Send a message via MSN to ReSpawN
ReSpawN is offline  
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT. The time now is 07:05 AM.

 
     

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Inactive Reminders By Icora Web Design