This may be done basically by index.php, by running a script in the
background that selects members whose levy is becoming due and have not
already been notified , sends a standard email to the member's email
address and updates a `notification_sent` field with, say, a timestamp
value.
A
MySql 4.1.21
ISAM table
The table has a many fields and a number of rows with auto-incremented ID
I need to set the value in particular fields for some rows to NULL.
Is there a simpler way of doing this than by setting the value for each
of the particular fields to NULL using an UPDATE
Tom Crimmins wrote:
On Wednesday, April 13, 2005 20:17, [EMAIL PROTECTED] wrote:
MySql vers 4.0.20
A table noticeboard has three test entries.
A unix time from date(U) is stored in the field published of
type, bigint20.
I am not able to workout how to select the year. Assuming that the
?
...
...
/* Performing SQL query */
$query = SELECT * FROM ServiceStatus;
$result = mysql_query($query) or die(Query failed : . mysql_error());
?
!-- Printing results in HTML catering for all browsers --
div style=text-align:center;
table border=1 cellpadding=5 cellspacing=0
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: boclair [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, February 07, 2003 8:47 AM
Subject: Re: Using SET in the INSERT statement
: At 14:19 +1000 2/5/03, boclair wrote:
: I notice some of my colleagues using SET in INSERT
PROTECTED]
To: boclair [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 6:17 AM
Subject: RE: Using SET in the INSERT statement
: Are you referring to the data type SET or the Command SET? The manual
page
: you point to is talking about the data type, but usually when seen
- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 6:47 AM
Subject: Re: Using SET in the INSERT statement
: On 5 Feb 2003, at 14:19, boclair wrote:
:
: I notice some of my colleagues using SET in INSERT statements
I notice some of my colleagues using SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The Manual has some mention in http://www.mysql.com/doc/en/SET.html
I sort of get it but I am looking for a fuller explanation.
Louise
I notice some of my colleagues have used SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The Manual has some mention in http://www.mysql.com/doc/en/SET.html
I sort of get it but I am looking for a fuller explanation.
Louise
(for the filter this time:
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 5:31 AM
Subject: possible bug in sum() function
select sum(worktime) from timecard where tcacct=project;
The answer came back 182. Then I was asked who had spent time on
the project.
the
10 matches
Mail list logo