I maintain a site for an athletic club, and on it I have a form that people
can submit that requests a free guest pass. The form contents are sent to
an address at the club, and then the club contacts the person to make an
appointment. The club would like to start logging the requests and then get
weekly updates sent to them via e-mail of all the guest pass requests
submitted. Logging the requests and creating the e-mail with all the
requests is easy enough. What I would like to know is if it possible to
have the e-mail created and sent automatically on a weekly basis without any
interaction from the user. I've looked through the PHP and MySQL manuals
and didn't see any type of reference to this.
Thanks.
Steve
3  2614 
try crontab
"Steve Edwards" <s.*******@comc ast.net> ¦b¶l¥ó
news:I4ubb.5428 33$o%2.240026@s ccrnsc02 ¤¤¼¶¼g... I maintain a site for an athletic club, and on it I have a form that
people can submit that requests a free guest pass. The form contents are sent to
an address at the club, and then the club contacts the person to make an
appointment. The club would like to start logging the requests and then
get weekly updates sent to them via e-mail of all the guest pass requests
submitted. Logging the requests and creating the e-mail with all the
requests is easy enough. What I would like to know is if it possible to
have the e-mail created and sent automatically on a weekly basis without
any interaction from the user. I've looked through the PHP and MySQL manuals
and didn't see any type of reference to this.
Thanks.
Steve
"Steve Edwards" <s.*******@comc ast.net> wrote in message
news:I4ubb.5428 33$o%2.240026@s ccrnsc02... I maintain a site for an athletic club, and on it I have a form that
people can submit that requests a free guest pass. The form contents are sent to
an address at the club, and then the club contacts the person to make an
appointment. The club would like to start logging the requests and then
get weekly updates sent to them via e-mail of all the guest pass requests
submitted. Logging the requests and creating the e-mail with all the
requests is easy enough. What I would like to know is if it possible to
have the e-mail created and sent automatically on a weekly basis without
any interaction from the user. I've looked through the PHP and MySQL manuals
and didn't see any type of reference to this.
Thanks.
Steve
If you have a Unix/Linux box, you could use cron or crontab... this is a
linux/unix utility, not a PHP or MySQL utility.
If you don't have this, or don't have access to it, you won't be able to do
it without some user intervention... . or at least, not anything near
reliable...
Ugh... there's always window's (task) scheduler
"Randell D." <yo************ **************@ yahoo.com> wrote in message news:<jT******* *************** **@news2.calgar y.shaw.ca>... "Steve Edwards" <s.*******@comc ast.net> wrote in message
news:I4ubb.5428 33$o%2.240026@s ccrnsc02... I maintain a site for an athletic club, and on it I have a form that
people can submit that requests a free guest pass. The form contents are sent to
an address at the club, and then the club contacts the person to make an
appointment. The club would like to start logging the requests and then
get weekly updates sent to them via e-mail of all the guest pass requests
submitted. Logging the requests and creating the e-mail with all the
requests is easy enough. What I would like to know is if it possible to
have the e-mail created and sent automatically on a weekly basis without
any interaction from the user. I've looked through the PHP and MySQL manuals
and didn't see any type of reference to this.
Thanks.
Steve
If you have a Unix/Linux box, you could use cron or crontab... this is a
linux/unix utility, not a PHP or MySQL utility.
If you don't have this, or don't have access to it, you won't be able to do
it without some user intervention... . or at least, not anything near
reliable... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Filips Benoit |
last post by:
Dear All,
I need to send faxes from Access to some companies that doesn't have a
computer (!) or some that prefer receiving a fax.
On Friday-evening a routine should send a ToDo-list for the next week to all
the contractants. Most as email but some as fax.
The routine loops all contractants, checks the send-mode and send to the
ToDo-list.
The hole routine sends about 30 emails and 10 faxes.
Before i finish the routine and start testing...
|
by: Shunya |
last post by:
Hi,
I got to know the way in which we can use record,pl/sql table as
input parameter to the procedure but couldn't get the way by which we
can call such procedure from asp.net.
Suppose we have a procedure having Pl/sql table or record set as a
input parameter and we want to call such procedure from asp.net how can
we do that? I tried using cursor but it is giveing error that cursor
can be used only as a out parameter.
Please suggest a...
|
by: Tony |
last post by:
I have a situation where I want to send data, but I have no need for a
response. It seems to me that XMLHTTPRequest is the best way to send the
data, but I don't need any response back from the server.
Basically, I'm writing js errors to an error log on the server side -
and there is no need to inform the user that the error has been logged.
The problem is that I don't want to sit with the request open & waiting
for a response, when I...
|
by: jerry.ranch |
last post by:
I have a macro that autoruns once weekly and sends an email with an
attached xls file ( a data extract) to some internal customers.
The subject always reads , for example...is there a way
to add a date into the subject field based on system date like
Subject: 06/17/2006
Thanks
|
by: dave |
last post by:
Hi,
Can someone get me started by pointing me to an example or tutorial.
I am displaying some weekly sales data using the GridView. The data
shows all sales data. I would like to group it by date and have
weekly summaries. Some weeks may have many sales some, not so many.
Also, I don't want to persist this info to the database; it changes as
people add/subtract sales. So, as I render the data I need to have a
row after each week...
| | |
by: mochatrpl |
last post by:
I am looking for a way to make a query / report display the running
average for total dollars.
I have already set up a query to provide totals dollars per day from
which a report graphly shows the dollars per week. How do I then take
the dollars and get a running average for the year?
- Randy
|
by: azimid |
last post by:
Hello everyone,
I need your help with a query.
Currently I display the data in a daily format. I have a form that the
users submits the date range (from say 20061224 to 20070530) and the
data is displayed daily.
I like to know how I can show the data in weekly and monthly way.so
that for the range shown above I would have the monthly or weekly
|
by: ambelkar |
last post by:
hi,
I trying to join weekly & daily tables by using end_dte,Rpt_dte respectively.My week is saturday to friday.first table only having week end' dates but the 2 daily table having daily dates .when I trying to join 2 tables using the following condition
weekly.end_dte=Next_day(daily.rpt_dte,'FRI')
only for this friday's date it displays next friday's date.
for ex: 7th is friday when I give next_day('04-05-2007', 'fri') , it should...
|
by: Lucas_london via AccessMonster.com |
last post by:
Hi
I have set up a database/tables in Access based on daily timeseries data.
However I would like to create two additional columns in the table as a basis
to pull the data on a weekly and monthly series basis.
Currently, in excel I am using the weekday and EOMONTH functions to create
the flags/indicator in my excel dataset:
(Cells in column A contains daily dates)
|
by: associates |
last post by:
Hi,
I desperately need your help here. I'm trying to work out a better way of producing a weekly report for a job that should show the weekly activities for last week and the current week using Access 03.
In the table "weeklytable", i have the following fields
WeeklyID
WeeklyActivities
ProposedActivities
WeekNo
Date
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
