Always nice to know when something is not too serious :-).
-Oorspronkelijk bericht-
Van: Rick Emery [mailto:[EMAIL PROTECTED]]
Verzonden: Friday, November 02, 2001 5:05 PM
Aan: PHP DB list
Onderwerp: RE: [PHP-DB] sending bulk emails
my comment was humor. we've already explored and kill
eople)
don't like.
Robert Klinkenberg
-Oorspronkelijk bericht-
Van: Rick Emery [mailto:[EMAIL PROTECTED]]
Verzonden: Friday, November 02, 2001 2:26 PM
Aan: PHP DB list
Onderwerp: RE: [PHP-DB] sending bulk emails
Opswe've just armed a potential spammer...
--
PHP Databa
after each other
without transactions but this might
lead to concurrency problems
Robert Klinkenberg
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
instead of actually
deleting
the user
Robert Klinkenberg
> -Oorspronkelijk bericht-
> Van: RSalomo [SMTP:[EMAIL PROTECTED]]
> Verzonden:Wednesday, August 15, 2001 11:21 AM
> Aan: [EMAIL PROTECTED]
> Onderwerp:[PHP-DB] delete user but keep the article
>
> hi,
>
You could also do a select sum(counter) from
or, if the db supports it, select avg(...) from ...
Saves you the trouble of counting.
Robert Klinkenberg
> Van: Andre P. [SMTP:[EMAIL PROTECTED]]
> Verzonden:Wednesday, August 15, 2001 6:48 PM
> Aan: [EMAIL PROTECTED]
>
of blank fields.
Robert Klinkenberg
> -Oorspronkelijk bericht-
> Van: Ian Grant [SMTP:[EMAIL PROTECTED]]
> Verzonden:Wednesday, July 25, 2001 6:28 PM
> Aan: [EMAIL PROTECTED]
> Onderwerp:[PHP-DB] Re: Making a new row in HTML tables
>
> Yeah, but if I had 3
MySQL supports transactions so you can submit multiple SQL statements
and commit them all at once.
example of statement (from www.mysql.com)
BEGIN;
SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET summmary=@A WHERE type=1;
COMMIT;
Robert Klinkenberg
MessageID.
This said, I mostly work with either Oracle or MS-SQL so mysql can still
cause
problems. ( I always was a bit shy of using mysql as it didn't support a lot
of
functions that IMOH should be in a real db, like transactions and Ref
integrity,
but that seems to have changed nowadays)
R
