Future Event

Is there a way in php to execute a SELECT statement in the future? What
I am wanting to do is use a page to parse a database at a future time.
I want to send out some email about an event I am putting on, but I
don't want to execute the select statement until 2:00am. I could use
cron for this, but I would perfer not, as I am writing an application in
which cron may not be an option. Is there 3rd party engines that will
do this?


Mark

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Future Event

Put it all in a separate page and call that page from another machine where
CRON/SCheduled Tasks are allowed....or put a time check in your page and
call it like a function whevever users hit your site

bastien


>From: Mark Bomgardner
>Reply-To: mbomgardner@kletc.org
>To: Php-Db
>Subject: [PHP-DB] Future Event
>Date: Mon, 20 Feb 2006 13:45:18 -0600
>
>Is there a way in php to execute a SELECT statement in the future? What I
>am wanting to do is use a page to parse a database at a future time. I
>want to send out some email about an event I am putting on, but I don't
>want to execute the select statement until 2:00am. I could use cron for
>this, but I would perfer not, as I am writing an application in which cron
>may not be an option. Is there 3rd party engines that will do this?
>
>
>Mark
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Future Event

On Mon, 20 Feb 2006, Mark Bomgardner wrote:

> Is there a way in php to execute a SELECT statement in the future? What I am
> wanting to do is use a page to parse a database at a future time. I want to
> send out some email about an event I am putting on, but I don't want to
> execute the select statement until 2:00am. I could use cron for this, but I
> would perfer not, as I am writing an application in which cron may not be an
> option. Is there 3rd party engines that will do this?
>
>
> Mark
>
>

i think u can just use the time constraint :-? I think its possible

raj


--

Your absence should be long enough so that someone miss you ,
But it shouldn't be so long enough that
Someone learns to live without you
So keep in touch !

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Future Event

Mark Bomgardner wrote:

> Is there a way in php to execute a SELECT statement in the future? What

only if its running in the future :)

You can trigger it when a visitor visits your page but what are the
chances someone will visit it at 2:000 AM exactly every night?

You can run it as a daemon, which woudl be kind of stupid, plus if they
don;t let you run cron they probably don;t want a script to run 24/7
just to send an email at 2:00 AM

You can cron it.

You can cron a script on a different server to run your script on the
non-cron machine via SSH, HTTP, etc...

BTW, this applies to scripting of any kind, Actually there are soem Perl
modules that can do this, have you looked on CPAN?

> I am wanting to do is use a page to parse a database at a future time.
> I want to send out some email about an event I am putting on, but I
> don't want to execute the select statement until 2:00am. I could use
> cron for this, but I would perfer not, as I am writing an application in
> which cron may not be an option. Is there 3rd party engines that will
> do this?

Yes, Cron is one that 99% of servers will have and several Perl Modules
on CPAN.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php