[PHP-DB] Re: PEAR DB
Martin wrote: > Pardon an exceedingly dumb question. > Where do I find documentation on HOW to use the PEAR DB class? > What functions to call and what they do? > > Martin S Dont bother, found one. (i.e. why didn't I use Google in the first place?). /M. -- 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]
[PHP-DB] Forms error in a catalog by Greenspan & Bulger
Greetings All!
I am working on making a catalog from the example used in "MySQL/PHP
Databases Applications" by Jay Greenspan andBrad Bulger. I am using
php3 on the remote unix server. I had to remain all the php files
and there references in the documents from .php to .php3. I am
editing the code in a "simple text"editor.
Here is the problem. I keep getting a Parse error on line 33.
Question 1) How are you suposed count the lines? What is the exact
definition of a line?
Question 2) Can anybody tell me where the error is and or how to fix
it? Enclosed is the code.
Thanks very much in advance for any help or comments.
Darren
Here Tis...
tag. If the first argument
// is empty, the value of the global Apache variable SCRIPT_NAME
// is used for the 'action' attribute of the tag. Other
// attributes for the form can be specified in the optional second
// argument; the default method of the form is "post".
// The behavior of this function on servers other than Apache is
// not known. It's likely that it will work, as SCRIPT_NAME is
// part of the CGI 1.1 specification.
function start_form ($action="", $atts="")
{
global $SCRIPT_NAME;
if (empty($action)) { $action = $SCRIPT_NAME; }
$attlist = get_attlist($atts,array("method"=>"post"));
$output = <<
EOQ;
return $output;
}
// string end_form(void)
// This function returns an HTML tag.
function end_form ()
{
$output = <<
EOQ;
return $output;
}
// string text_field ([string name [, string value [, int size [,
int maximum length)
// This function returns an HTML text input field. The default size
// of the field is 10. A value and maximum data length for the field
// may be supplied.
function text_field ($name="", $value="", $size=10, $maxlen="")
{
$maxatt = empty($maxlen) ? "" : "maxlength=\"$maxlen\"";
$output = <<
EOQ;
return $output;
}
// string textarea_field([string name [, string value [, int cols [,
int rows [, string wrap mode])
// This function returns an HTML textarea field. The default size is
// 50 columns and 10 rows, and the default wrap mode is 'soft',
which means
// no hard newline characters will be inserted after line breaks in what
// the user types into the field. The alternative wrap mode is 'hard',
// which means that hard newlines will be inserted.
function textarea_field ($name="", $value="", $cols=50, $rows=10,
$wrap="soft")
{
$output = <<$value
EOQ;
return $output;
}
// string password_field ([string name [, string value [, int size
[, int maximum length)
// This function returns an HTML password field. This is like a text
field,
// but the value of the field is obscured (only stars or bullets are
visible
// for each character). The default size of the field is 10. A
starting
// value and maximum data length may be supplied.
function password_field ($name="", $value="", $size=10, $maxlen="")
{
$output = <<
EOQ;
return $output;
}
// string hidden_field ([string name [, string value]])
// This function returns an HTML hidden field. A value may be supplied.
function hidden_field ($name="", $value="")
{
$output = <<
EOQ;
return $output;
}
// string file_field ([string name])
// This function returns an HTML file field. These are used to specify
// files on the user's local hard drive, typically for uploading as
// part of the form. (See
http://www.zend.com/manual/features.file-upload.php
// for more information about this subject.)
function file_field ($name="")
{
$output = <<
EOQ;
return $output;
}
// string submit_field ([string name [, string value]])
// This function returns an HTML submit field. The value of the field
// will be the string displayed by the button displayed by the user's
// browser. The default value is "Submit".
function submit_field ($name="", $value="")
{
if (empty($value)) { $value = "Submit"; }
$output = <<
EOQ;
return $output;
}
// string image_field ([string name [, string src [, string value]]])
// This function returns an HTML image field. An image field works
// likes a submit field, except that the image specified by the URL
// given in the second argument is displayed instead of a button.
function image_field ($name="", $src="", $value="")
{
if (empty($value)) { $value = $name; }
$output = <<
EOQ;
return $output;
}
// string reset_field ([string name [, string value]])
// This function returns an HTML reset field. A reset field returns
// the current form to its original state.
function reset_field ($name="reset", $value="Reset")
{
$output = <<
EOQ;
return $output;
}
// string checkbox_field ([string name [, string value [, string
label [, string match)
// This function returns an HTML checkbox field. The optional third
argument
// will be included immediately after the checkbox field, and the pair
// is includ
[PHP-DB] PEAR DB
Pardon an exceedingly dumb question. Where do I find documentation on HOW to use the PEAR DB class? What functions to call and what they do? Martin S -- 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]
[PHP-DB] err:parae error not defined function -----
I installed mysql & php with redhat 7.1 RPM package , they can work well
respectively .but when I use function
mysql_connect("hostname","user","password")to connect mysql , the err
message shows that , "parse err not defined function
mysql_connect().what's up ?help me!
--
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]
Re: [PHP-DB] losing first row of an array
Nice to see someone else is up!
Most times I print result sets as given
is
inside a
do
echo"$row[fieldname]
while loop
but when putting html with it ie. building a table tr td td td td tr
etc...etc.
you have to close rows before starting new cells
data is then shown
fieldname1 fieldname2
data_for_row1 data_for_row1
data_for_row2 data_for_row2
what i would like to do is transpose data so as to write as shown like this
fieldname1 data_for_row1 data_for_row2
fieldname2 data_for_row1 data_for_row2
I think a for while do loop would work with ++ inexing but u lose the field
calling ability
any ideas??
or is it just 12.40am here in the UK
Cheers
Sean
Matthew Loff <[EMAIL PROTECTED]> wrote in message
006401c163fd$bbb34bd0$0ce60281@bang">news:006401c163fd$bbb34bd0$0ce60281@bang...
>
> I don't quite get what you're asking... Could you be more specific?
>
>
> -Original Message-
> From: Seany [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 02, 2001 5:48 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] losing first row of an array
>
>
> nice spot I went blind for a min.lol
>
> is there any to write columns first but still call fields with headers?
> as writing in a table would not allow keeping tags open
> ie.
> echo"col[1]";
> echo"col[2]";
>
> array_flip do the job?
> but how?
>
> Sean
>
>
>
> Matthew Loff <[EMAIL PROTECTED]> wrote in message
> 005c01c163e0$5716ca20$0ce60281@bang">news:005c01c163e0$5716ca20$0ce60281@bang...
> >
> > You are overwriting the first row.
> >
> > $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
> > clubac.ac_year, clubac.ac_type, club.id
> > FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
> > club.id");
> >
> > if(mysql_num_rows())
> > while ($row = mysql_fetch_array($result)
> > {
> > echo "$row[club_id]";
> > echo "$row[id]";
> > echo "$row[ac_year]";
> > echo "$row[ac_type]";
> > }
> > else .blablabla
> >
> > ...Or...
> >
> > $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
> > clubac.ac_year, clubac.ac_type, club.id
> > FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
> > club.id");
> >
> > $row = mysql_fetch_array($result);
> >
> > if ($row)
> > do {
> > echo "$row[club_id]";
> > echo "$row[id]";
> > echo "$row[ac_year]";
> > echo "$row[ac_type]";
> > } while($row = mysql_fetch_array($result));
> > else .blablabla
> >
> >
> > -Original Message-
> > From: Seany [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 02, 2001 2:09 PM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP-DB] losing first row of an array
> >
> >
> > having this code running PHP4.0b2
> >
> > $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
> > clubac.ac_year, clubac.ac_type, club.id
> > FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
> > club.id");
> >
> > $row = mysql_fetch_array($result);
> >
> > if ($row = mysql_fetch_array($result)) {
> >
> > do {
> > echo "$row[club_id]";
> > echo "$row[id]";
> > echo "$row[ac_year]";
> > echo "$row[ac_type]";
> >
> > } while($row = mysql_fetch_array($result));
> >
> > } else .blablabla
> >
> > is there a fundamental miss on my part why the is printing the first
> or
> > not
> > even recognising it
> > if call direct in mysql with the above query it's fine with the
> results
> > even
> > if there is 1 row
> >
> > duh???
> >
> > Seany
> >
> >
> >
> > --
> > 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]
> >
>
>
>
> --
> 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]
>
--
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]
[PHP-DB] $this->TRAIL = $trail
Can someone explain what this is, either in the
context below or just in general. I do not understand
what this statement means?
10 var $TRAIL = array();
129 while ( $row = mysql_fetch_array($results))
130 {
131 $trail = $this->TRAIL;
132 $count = count($trail);
133 $trail[$count] = $row;
134 $this->TRAIL = $trail;
135 $id = $row["CatParent"];
136 $this->get_Parents($id);
137 }
sql query is "SELECT CatID,CatParent,CatName from
Categories where CatID = $CatID";
Lines excerted from phpHoo article here:
http://www.webreference.com/perl/xhoo/php1/
Thanks,
olinux
__
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com
--
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]
RE: [PHP-DB] losing first row of an array
I don't quite get what you're asking... Could you be more specific?
-Original Message-
From: Seany [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 5:48 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] losing first row of an array
nice spot I went blind for a min.lol
is there any to write columns first but still call fields with headers?
as writing in a table would not allow keeping tags open
ie.
echo"col[1]";
echo"col[2]";
array_flip do the job?
but how?
Sean
Matthew Loff <[EMAIL PROTECTED]> wrote in message
005c01c163e0$5716ca20$0ce60281@bang">news:005c01c163e0$5716ca20$0ce60281@bang...
>
> You are overwriting the first row.
>
> $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
> clubac.ac_year, clubac.ac_type, club.id
> FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
> club.id");
>
> if(mysql_num_rows())
> while ($row = mysql_fetch_array($result)
> {
> echo "$row[club_id]";
> echo "$row[id]";
> echo "$row[ac_year]";
> echo "$row[ac_type]";
> }
> else .blablabla
>
> ...Or...
>
> $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
> clubac.ac_year, clubac.ac_type, club.id
> FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
> club.id");
>
> $row = mysql_fetch_array($result);
>
> if ($row)
> do {
> echo "$row[club_id]";
> echo "$row[id]";
> echo "$row[ac_year]";
> echo "$row[ac_type]";
> } while($row = mysql_fetch_array($result));
> else .blablabla
>
>
> -Original Message-
> From: Seany [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 02, 2001 2:09 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] losing first row of an array
>
>
> having this code running PHP4.0b2
>
> $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
> clubac.ac_year, clubac.ac_type, club.id
> FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
> club.id");
>
> $row = mysql_fetch_array($result);
>
> if ($row = mysql_fetch_array($result)) {
>
> do {
> echo "$row[club_id]";
> echo "$row[id]";
> echo "$row[ac_year]";
> echo "$row[ac_type]";
>
> } while($row = mysql_fetch_array($result));
>
> } else .blablabla
>
> is there a fundamental miss on my part why the is printing the first
or
> not
> even recognising it
> if call direct in mysql with the above query it's fine with the
results
> even
> if there is 1 row
>
> duh???
>
> Seany
>
>
>
> --
> 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]
>
--
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]
--
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]
Re: [PHP-DB] losing first row of an array
nice spot I went blind for a min.lol
is there any to write columns first but still call fields with headers?
as writing in a table would not allow keeping tags open
ie.
echo"col[1]";
echo"col[2]";
array_flip do the job?
but how?
Sean
Matthew Loff <[EMAIL PROTECTED]> wrote in message
005c01c163e0$5716ca20$0ce60281@bang">news:005c01c163e0$5716ca20$0ce60281@bang...
>
> You are overwriting the first row.
>
> $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
> clubac.ac_year, clubac.ac_type, club.id
> FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
> club.id");
>
> if(mysql_num_rows())
> while ($row = mysql_fetch_array($result)
> {
> echo "$row[club_id]";
> echo "$row[id]";
> echo "$row[ac_year]";
> echo "$row[ac_type]";
> }
> else .blablabla
>
> ...Or...
>
> $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
> clubac.ac_year, clubac.ac_type, club.id
> FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
> club.id");
>
> $row = mysql_fetch_array($result);
>
> if ($row)
> do {
> echo "$row[club_id]";
> echo "$row[id]";
> echo "$row[ac_year]";
> echo "$row[ac_type]";
> } while($row = mysql_fetch_array($result));
> else .blablabla
>
>
> -Original Message-
> From: Seany [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 02, 2001 2:09 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] losing first row of an array
>
>
> having this code running PHP4.0b2
>
> $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
> clubac.ac_year, clubac.ac_type, club.id
> FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
> club.id");
>
> $row = mysql_fetch_array($result);
>
> if ($row = mysql_fetch_array($result)) {
>
> do {
> echo "$row[club_id]";
> echo "$row[id]";
> echo "$row[ac_year]";
> echo "$row[ac_type]";
>
> } while($row = mysql_fetch_array($result));
>
> } else .blablabla
>
> is there a fundamental miss on my part why the is printing the first or
> not
> even recognising it
> if call direct in mysql with the above query it's fine with the results
> even
> if there is 1 row
>
> duh???
>
> Seany
>
>
>
> --
> 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]
>
--
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]
RE: [PHP-DB] losing first row of an array
You are overwriting the first row.
$result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
clubac.ac_year, clubac.ac_type, club.id
FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
club.id");
if(mysql_num_rows())
while ($row = mysql_fetch_array($result)
{
echo "$row[club_id]";
echo "$row[id]";
echo "$row[ac_year]";
echo "$row[ac_type]";
}
else .blablabla
...Or...
$result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
clubac.ac_year, clubac.ac_type, club.id
FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
club.id");
$row = mysql_fetch_array($result);
if ($row)
do {
echo "$row[club_id]";
echo "$row[id]";
echo "$row[ac_year]";
echo "$row[ac_type]";
} while($row = mysql_fetch_array($result));
else .blablabla
-Original Message-
From: Seany [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 2:09 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] losing first row of an array
having this code running PHP4.0b2
$result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
clubac.ac_year, clubac.ac_type, club.id
FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
club.id");
$row = mysql_fetch_array($result);
if ($row = mysql_fetch_array($result)) {
do {
echo "$row[club_id]";
echo "$row[id]";
echo "$row[ac_year]";
echo "$row[ac_type]";
} while($row = mysql_fetch_array($result));
} else .blablabla
is there a fundamental miss on my part why the is printing the first or
not
even recognising it
if call direct in mysql with the above query it's fine with the results
even
if there is 1 row
duh???
Seany
--
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]
--
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]
Re: [PHP-DB] losing first row of an array
On Friday, November 2, 2001, at 01:09 PM, Seany wrote:
> having this code running PHP4.0b2
>
> $result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
> clubac.ac_year, clubac.ac_type, club.id
> FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
> club.id");
>
> $row = mysql_fetch_array($result);
Here you've fetched the first row...
>
> if ($row = mysql_fetch_array($result)) {
...and here you've overwritten it with the second row.
You probably just want: if ($row) { ...
>
> do {
> echo "$row[club_id]";
> echo "$row[id]";
> echo "$row[ac_year]";
> echo "$row[ac_type]";
>
> } while($row = mysql_fetch_array($result));
>
> } else .blablabla
>
> is there a fundamental miss on my part why the is printing the first or
> not
> even recognising it
> if call direct in mysql with the above query it's fine with the results
> even
> if there is 1 row
>
> duh???
>
> Seany
>
>
>
> --
> 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]
>
--
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]
Re: [PHP-DB] RE: [PHP-WIN] Can I rotate a gif with PHP
> that produce a gif and then calling that gif as part of the report. But > I need to rotate this gif 90 degrees CW. > > Can I do that with PHP? > > Platform > - > W2K > MySQL > PHP 4.04 > > Let me clarify this. The app is written in PHP and I cannot find > anything that references rotating an image in the PHP docs. There is > some reference to rotating images in a pdf with PHP, but nothing else. > > Anyone have any ideas? Take a look at the tool imagemagick http://www.imagemagick.org It provides a lot of usefull functions (convert, resize, rotate,...) and available for w2k. Just call the command line within the php. hth, pa -- 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]
[PHP-DB] RE: [PHP-WIN] Can I rotate a gif with PHP
Hello Everyone, I am generating some analylitical reports from a database using S-Plus that produce a gif and then calling that gif as part of the report. But I need to rotate this gif 90 degrees CW. Can I do that with PHP? Platform - W2K MySQL PHP 4.04 Let me clarify this. The app is written in PHP and I cannot find anything that references rotating an image in the PHP docs. There is some reference to rotating images in a pdf with PHP, but nothing else. Anyone have any ideas? -- Robert Trembath Internet Technology Manager e|[EMAIL PROTECTED] -- 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]
[PHP-DB] losing first row of an array
having this code running PHP4.0b2
$result = mysql_query("SELECT clubac.id AS clubacid, clubac.club_id,
clubac.ac_year, clubac.ac_type, club.id
FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id = club.id");
$row = mysql_fetch_array($result);
if ($row = mysql_fetch_array($result)) {
do {
echo "$row[club_id]";
echo "$row[id]";
echo "$row[ac_year]";
echo "$row[ac_type]";
} while($row = mysql_fetch_array($result));
} else .blablabla
is there a fundamental miss on my part why the is printing the first or not
even recognising it
if call direct in mysql with the above query it's fine with the results even
if there is 1 row
duh???
Seany
--
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]
Re: [PHP-DB] sending bulk emails
You should sort the addressees by domain first too, to give the MTA
a chance to opimize your spam delivery.
On Fri, Nov 02, 2001 at 04:44:06PM +, Shane Wright wrote:
> Hi
>
> I find that the best way to do it is with a script having a long/unlimited
> timeout, but limiting it to only a few hundred mails per execution in the SQL
> '... LIMIT 500'.
>
> IMO better this way than a short-timeout script - sending one email can
> sometimes take ages (long DNS lookup, slow connection to the host, etc...)
>
> Shane
>
>
> On Friday 02 November 2001 4:18 pm, Jonathan Hilgeman wrote:
> > Interesting that this should come up. The company I work for needs to send
> > out an e-mail to 95k of their subscribers. Now, this is the first time in 2
> > years, so you can imagine that we'll be getting 94k of bounced e-mail
> > addresses. So I'm writing a script that will handle sending out the e-mails
> > and handling incoming bounced e-mail addresses. In any case, I would think
> > that my PHP script would time out before sending 95k e-mails. I know it has
> > timed out at 30 seconds before, but I can't remember if the faulty script
> > had an endless loop for 30 seconds or if there was any data getting sent or
> > received in that time. Anyone know beforehand whether I will get a timeout
> > with sending these e-mails, and if so, how to work around it?
> >
> > - Jonathan
> >
> > -Original Message-
> > From: Russ Michell [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 02, 2001 4:20 AM
> > To: Cami
> > Cc: PHP DB list
> > Subject: Re: [PHP-DB] sending bulk emails
> >
> > > Does anybody know how to send bulk emails using php?
> >
> > Don't do it!!
> >
> > But of you must - I guess you could build an array containing email
> > addresses, names, etc - taken
> > from form input or a database or whatever and then loop the arrays mailing
> > people...
> >
> > $mail = "mail(";
> > for($i=0; $i<$email_array_name;$i++( {
> > $mail .= "$values,";
> > }
> > $mail .= "\"$subject\",\"$body\",\"From: $from\");";
> >
> > Something like that anyway (that's just off the top of my head)
> > Regards.
> >
> > Russ
> >
> > On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
> > > Hi guys,
> > > Does anybody know how to send bulk emails using php?
> > > Thanks,
> > > Cami
> > >
> > > --
> > > 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]
> >
> > #---#
> >
> > "Believe nothing - consider everything"
> >
> > Russ Michell
> > Anglia Polytechnic University Webteam
> > Room 1C 'The Eastings' East Road, Cambridge
> >
> > e: [EMAIL PROTECTED]
> > w: www.apu.ac.uk/webteam
> >
> > www.theruss.com
> >
> > #---#
>
> --
> Shane
>
> --
> 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]
>
--
--
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]
RE: [PHP-DB] sending bulk emails
Put this before each email goes out. It will give your script another 30
seconds to run.
set_time_limit(30);
-Jason Garber
IonZoft.com
At 08:18 AM 11/2/2001 -0800, Jonathan Hilgeman wrote:
>Interesting that this should come up. The company I work for needs to send
>out an e-mail to 95k of their subscribers. Now, this is the first time in 2
>years, so you can imagine that we'll be getting 94k of bounced e-mail
>addresses. So I'm writing a script that will handle sending out the e-mails
>and handling incoming bounced e-mail addresses. In any case, I would think
>that my PHP script would time out before sending 95k e-mails. I know it has
>timed out at 30 seconds before, but I can't remember if the faulty script
>had an endless loop for 30 seconds or if there was any data getting sent or
>received in that time. Anyone know beforehand whether I will get a timeout
>with sending these e-mails, and if so, how to work around it?
>
>- Jonathan
>
>-Original Message-
>From: Russ Michell [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 02, 2001 4:20 AM
>To: Cami
>Cc: PHP DB list
>Subject: Re: [PHP-DB] sending bulk emails
>
>
> > Does anybody know how to send bulk emails using php?
>Don't do it!!
>
>But of you must - I guess you could build an array containing email
>addresses, names, etc - taken
>from form input or a database or whatever and then loop the arrays mailing
>people...
>
>$mail = "mail(";
>for($i=0; $i<$email_array_name;$i++( {
> $mail .= "$values,";
> }
>$mail .= "\"$subject\",\"$body\",\"From: $from\");";
>
>Something like that anyway (that's just off the top of my head)
>Regards.
>
>Russ
>
>On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
>
> > Hi guys,
> > Does anybody know how to send bulk emails using php?
> > Thanks,
> > Cami
> >
> > --
> > 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]
> >
>
>#---#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
>#---#
>
>
>--
>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]
>
>--
>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]
--
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]
Re: [PHP-DB] sending bulk emails - mail() success/failure
Hi > The mail() entry in the manual does say that it returns a boolean for send > success/failure, however none of the examples make any use of such > feedback. Is there a way to work out if something has gone wrong with a > particular mail out, what the actual failure was, eg SMTP server down, DNS > lookup failed, slow connection time-out, etc? Indeed what will trigger a > FALSE return? > > Please advise, > =dn >From what I've seen/used of it, the true/false return isnt much use in most cases as most causes of failure dont cause the false return as they happen after the initial stage :( a false return can be caused by an immediate failure - i.e. user unknown on a local mailbox - but aside from that not a clue, sorry :( On a slightly OT note, I'm finding the best way to manage the whole process is to set up a temp email account and use that as the 'From' and 'Return Path' address, then have a PHP script receive mail from that mailbox and scan for undeliverables/unsubscribes and remove/disable them in the list as appropriate. Its a lot of work though :( -- Shane -- 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]
Re: [PHP-DB] sending bulk emails - mail() success/failure
Shane, You said: - > IMO better this way than a short-timeout script - sending one email can > sometimes take ages (long DNS lookup, slow connection to the host, etc...) - The mail() entry in the manual does say that it returns a boolean for send success/failure, however none of the examples make any use of such feedback. Is there a way to work out if something has gone wrong with a particular mail out, what the actual failure was, eg SMTP server down, DNS lookup failed, slow connection time-out, etc? Indeed what will trigger a FALSE return? Please advise, =dn -- 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]
Re: [PHP-DB] sending bulk emails
Hi
I find that the best way to do it is with a script having a long/unlimited
timeout, but limiting it to only a few hundred mails per execution in the SQL
'... LIMIT 500'.
IMO better this way than a short-timeout script - sending one email can
sometimes take ages (long DNS lookup, slow connection to the host, etc...)
Shane
On Friday 02 November 2001 4:18 pm, Jonathan Hilgeman wrote:
> Interesting that this should come up. The company I work for needs to send
> out an e-mail to 95k of their subscribers. Now, this is the first time in 2
> years, so you can imagine that we'll be getting 94k of bounced e-mail
> addresses. So I'm writing a script that will handle sending out the e-mails
> and handling incoming bounced e-mail addresses. In any case, I would think
> that my PHP script would time out before sending 95k e-mails. I know it has
> timed out at 30 seconds before, but I can't remember if the faulty script
> had an endless loop for 30 seconds or if there was any data getting sent or
> received in that time. Anyone know beforehand whether I will get a timeout
> with sending these e-mails, and if so, how to work around it?
>
> - Jonathan
>
> -Original Message-
> From: Russ Michell [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 02, 2001 4:20 AM
> To: Cami
> Cc: PHP DB list
> Subject: Re: [PHP-DB] sending bulk emails
>
> > Does anybody know how to send bulk emails using php?
>
> Don't do it!!
>
> But of you must - I guess you could build an array containing email
> addresses, names, etc - taken
> from form input or a database or whatever and then loop the arrays mailing
> people...
>
> $mail = "mail(";
> for($i=0; $i<$email_array_name;$i++( {
> $mail .= "$values,";
> }
> $mail .= "\"$subject\",\"$body\",\"From: $from\");";
>
> Something like that anyway (that's just off the top of my head)
> Regards.
>
> Russ
>
> On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
> > Hi guys,
> > Does anybody know how to send bulk emails using php?
> > Thanks,
> > Cami
> >
> > --
> > 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]
>
> #---#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
> #---#
--
Shane
--
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]
SV: [PHP-DB] sending bulk emails
Yes, you will get a timeout.
I made a script that wrote a * on the page for each sent mail.
This way your script won't time out, and the sending process looks REALLY
cool.. hehe
Here's a sample snippet:
\nContent-Type: text/plain;
charset=iso-8859-1\nContent-Transfer-Encoding: 8bit\nReply-To: Havneavisen
<[EMAIL PROTECTED]>\nReturn-Path:
<[EMAIL PROTECTED]>\nX-Sender:
<[EMAIL PROTECTED]>\nX-Mailer: PHP\nSender:
[EMAIL PROTECTED]\n") ;
if (!$send) {
# Legg inn i databasen eller fil! <
$table = "deadmail" ;
$dead_entry = "insert into deadmail (id, epost, base) VALUES
(\"$postid\",\"$to\",\"$base_1\")" ;
mysql_query($dead_entry) or die ("Could not store the bad mail") ;
echo "Problemer med å sende til $to" ;
continue ;
}
// Log
$go_add = "INSERT INTO maillogg (epost, dato, type) VALUES (\"$to\",
NOW(), \"$base_1\")" ;
$add_em = @mysql_query($go_add) ;
if (!$add_em) {
echo "ERROR could not update: $to - $go_add " ;
}
} end of while...
?>
> -Opprinnelig melding-
> Fra: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
> Sendt: 2. november 2001 17:19
> Til: '[EMAIL PROTECTED]'; Cami
> Kopi: PHP DB list
> Emne: RE: [PHP-DB] sending bulk emails
>
>
> Interesting that this should come up. The company I work for needs to send
> out an e-mail to 95k of their subscribers. Now, this is the first
> time in 2
> years, so you can imagine that we'll be getting 94k of bounced e-mail
> addresses. So I'm writing a script that will handle sending out
> the e-mails
> and handling incoming bounced e-mail addresses. In any case, I would think
> that my PHP script would time out before sending 95k e-mails. I
> know it has
> timed out at 30 seconds before, but I can't remember if the faulty script
> had an endless loop for 30 seconds or if there was any data
> getting sent or
> received in that time. Anyone know beforehand whether I will get a timeout
> with sending these e-mails, and if so, how to work around it?
>
> - Jonathan
>
> -Original Message-
> From: Russ Michell [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 02, 2001 4:20 AM
> To: Cami
> Cc: PHP DB list
> Subject: Re: [PHP-DB] sending bulk emails
>
>
> > Does anybody know how to send bulk emails using php?
> Don't do it!!
>
> But of you must - I guess you could build an array containing email
> addresses, names, etc - taken
> from form input or a database or whatever and then loop the arrays mailing
> people...
>
> $mail = "mail(";
> for($i=0; $i<$email_array_name;$i++( {
> $mail .= "$values,";
> }
> $mail .= "\"$subject\",\"$body\",\"From: $from\");";
>
> Something like that anyway (that's just off the top of my head)
> Regards.
>
> Russ
>
> On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
>
> > Hi guys,
> > Does anybody know how to send bulk emails using php?
> > Thanks,
> > Cami
> >
> > --
> > 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]
> >
>
> #---#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
> #---#
>
>
> --
> 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]
>
> --
> 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]
>
>
--
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]
RE: [PHP-DB] sending bulk emails
Interesting that this should come up. The company I work for needs to send
out an e-mail to 95k of their subscribers. Now, this is the first time in 2
years, so you can imagine that we'll be getting 94k of bounced e-mail
addresses. So I'm writing a script that will handle sending out the e-mails
and handling incoming bounced e-mail addresses. In any case, I would think
that my PHP script would time out before sending 95k e-mails. I know it has
timed out at 30 seconds before, but I can't remember if the faulty script
had an endless loop for 30 seconds or if there was any data getting sent or
received in that time. Anyone know beforehand whether I will get a timeout
with sending these e-mails, and if so, how to work around it?
- Jonathan
-Original Message-
From: Russ Michell [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 4:20 AM
To: Cami
Cc: PHP DB list
Subject: Re: [PHP-DB] sending bulk emails
> Does anybody know how to send bulk emails using php?
Don't do it!!
But of you must - I guess you could build an array containing email
addresses, names, etc - taken
from form input or a database or whatever and then loop the arrays mailing
people...
$mail = "mail(";
for($i=0; $i<$email_array_name;$i++( {
$mail .= "$values,";
}
$mail .= "\"$subject\",\"$body\",\"From: $from\");";
Something like that anyway (that's just off the top of my head)
Regards.
Russ
On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
> Hi guys,
> Does anybody know how to send bulk emails using php?
> Thanks,
> Cami
>
> --
> 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]
>
#---#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
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]
--
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]
SV: [PHP-DB] sending bulk emails
Come on ppl! You can't seriously say that we have become evil creatures luring idees on the list..? come on man! > -Opprinnelig melding- > Fra: Rick Emery [mailto:[EMAIL PROTECTED]] > Sendt: 2. november 2001 17:05 > Til: PHP DB list > Emne: RE: [PHP-DB] sending bulk emails > > > my comment was humor. we've already explored and killed this thread. > > -Original Message- > From: Robert Klinkenberg [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 02, 2001 9:44 AM > To: 'Rick Emery'; PHP DB list > Subject: RE: [PHP-DB] sending bulk emails > > > Interesting, instead of blocking access to programming tricks because the > company wants to protect its investments (or the government > doesn't like us > using it (think PGP)) we are now not telling people how to make good > software because somebody might use it to do something we (or some people) > 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 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] > > -- 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]
RE: [PHP-DB] sending bulk emails
my comment was humor. we've already explored and killed this thread. -Original Message- From: Robert Klinkenberg [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 9:44 AM To: 'Rick Emery'; PHP DB list Subject: RE: [PHP-DB] sending bulk emails Interesting, instead of blocking access to programming tricks because the company wants to protect its investments (or the government doesn't like us using it (think PGP)) we are now not telling people how to make good software because somebody might use it to do something we (or some people) 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 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]
Re: [PHP-DB] UPDATE table1 FROM table2
This is actually one of the more common MySQL problems which doesn't have an easy answer. The best I can offer is a bit of a kludge... but it does work. The trick is to use the Replace...Select command. The problem with this is that you can not select from the table you are replacing. But if you make a temporary copy of the tabe you are updating, then what you are wanting to do can be done with $query = "create temporary table temp select * from table1; replace table1 select temp.id,table2.value2,temp.colname from table2 left join temp using(id)"; You just have to make sure all of the columns in table1 you don't want changed appear as temp.colname. The temp table will only exist as long as the thread does, since it was created with the temporary keyword. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: "m0sh3" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 02, 2001 5:14 AM Subject: [PHP-DB] UPDATE table1 FROM table2 > In MySQL 3.23, how to update one table using information from another table. > > update table1 set value1=t2.value2 > from table1 as t inner join table2 as t1 using(pk_key) ??? > > or > > update table1 as t1 inner join table2 as t2 using(pk_key) > set t1.value1=t2.value2 ??? > > Is it possible at all? > > Thank you > > > > -- > 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] -- 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]
RE: [PHP-DB] sending bulk emails
Interesting, instead of blocking access to programming tricks because the company wants to protect its investments (or the government doesn't like us using it (think PGP)) we are now not telling people how to make good software because somebody might use it to do something we (or some people) 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 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]
RE: RE: [PHP-DB] sending bulk emails
Oh dear, Please do not worry. I would never send spam emails. One of my clients for which I am developing a database want to be able to send his members emails . The problem would have been simple if he had a few members but he has tens of tousands. So with some help from some of you and adopting a send mail library I think that now is in the process of being sorted. So just to calm you guys down. I would never do a spam email. Thank you everybody for your help, Cami -- 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]
Re: RE: [PHP-DB] sending bulk emails
Hi
If he's going to do it, it should at least be done safely...
- have a status field in your database table (unsent/sent/error)
- update the status field after _every_ email you send.
- do NOT do this in a transaction (otherwise if something dies everything is
forgotten)
- if the update status query fails, do everything possible to avoid carrying
on (important if the sending job is in crontab) - this can even be things
like renaming the database table, deleting itself, anything to make sure it
doesnt screw up and send any emails that it shouldnt
- dont send too fast. 1000-2000 per hour is good.
- be VERY VERY VERY careful that all the recipients have GIVEN PERMISSION for
you to email them. Its not worth the hassle of annoying people or risking
getting your mail hub blacklisted.
General philosophy: sending too few mails or missing out the odd recipient
doesnt matter, but NEVER send too many or any duplicates to any person.
Just my 2c
Shane
On Friday 02 November 2001 1:40 pm, Rick Emery wrote:
>
> True...so very true...
>
> A little knowledge is a dangerous thing. In the hands of a spammer...a
> deadly thing...
>
>
> -Original Message-
> From: Russ Michell [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 02, 2001 7:34 AM
> To: Rick Emery
> Cc: PHP DB list
> Subject: Re: RE: [PHP-DB] sending bulk emails
>
>
> Hmmm this is true - but as someone once wrote on this list:
>
> "If someone want's to build a car with 4 reverse gears, we can tell them
> it's not a very good idea,
> but we can also show them how to do it."
>
> Granted though - spam is a little different than cars!
> Cheers.
>
> Russ
>
> On Fri, 2 Nov 2001 07:26:15 -0600 Rick Emery <[EMAIL PROTECTED]> wrote:
> > Opswe've just armed a potential spammer...
> >
> > -Original Message-
> > From: Russ Michell [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 02, 2001 6:20 AM
> > To: Cami
> > Cc: PHP DB list
> > Subject: Re: [PHP-DB] sending bulk emails
> >
> > > Does anybody know how to send bulk emails using php?
> >
> > Don't do it!!
> >
> > But of you must - I guess you could build an array containing email
> > addresses, names, etc - taken
> > from form input or a database or whatever and then loop the arrays
> > mailing people...
> >
> > $mail = "mail(";
> > for($i=0; $i<$email_array_name;$i++( {
> > $mail .= "$values,";
> > }
> > $mail .= "\"$subject\",\"$body\",\"From: $from\");";
> >
> > Something like that anyway (that's just off the top of my head)
> > Regards.
> >
> > Russ
> >
> > On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
> > > Hi guys,
> > > Does anybody know how to send bulk emails using php?
> > > Thanks,
> > > Cami
> > >
> > > --
> > > 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]
> >
> > #---#
> >
> > "Believe nothing - consider everything"
> >
> > Russ Michell
> > Anglia Polytechnic University Webteam
> > Room 1C 'The Eastings' East Road, Cambridge
> >
> > e: [EMAIL PROTECTED]
> > w: www.apu.ac.uk/webteam
> >
> > www.theruss.com
> >
> > #---#
> >
> >
> > --
> > 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]
> >
> >
> >
> > --
> > 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]
>
> #---#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
> #---#
--
Shane
--
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]
RE: [PHP-DB] sending bulk emails
I just encountered the same problem...
I made a MySQL table with an email_id, email, and sentdate field.
while(true)
{
set_time_limit(10); //Give script 10 more seconds to run
SELECT email_id, email FROM thelist WHERE sentdate=0 LIMIT 1
if record not found, then break;
then I use the mail function to send it
UPDATE thelist SET sentdate=UNIX_TIMESTAMP() WHERE email_id=$email_id
then I use the sleep() or usleep() function to wait a second or so (so I
do not use too much bandwidth)
}
-Jason Garber
IonZoft.com
At 07:26 AM 11/2/2001 -0600, Rick Emery wrote:
>Opswe've just armed a potential spammer...
>
>-Original Message-
>From: Russ Michell [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 02, 2001 6:20 AM
>To: Cami
>Cc: PHP DB list
>Subject: Re: [PHP-DB] sending bulk emails
>
>
> > Does anybody know how to send bulk emails using php?
>Don't do it!!
>
>But of you must - I guess you could build an array containing email
>addresses, names, etc - taken
>from form input or a database or whatever and then loop the arrays mailing
>people...
>
>$mail = "mail(";
>for($i=0; $i<$email_array_name;$i++( {
> $mail .= "$values,";
> }
>$mail .= "\"$subject\",\"$body\",\"From: $from\");";
>
>Something like that anyway (that's just off the top of my head)
>Regards.
>
>Russ
>
>On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
>
> > Hi guys,
> > Does anybody know how to send bulk emails using php?
> > Thanks,
> > Cami
> >
> > --
> > 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]
> >
>
>#---#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
>#---#
>
>
>--
>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]
>
>
>
>--
>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]
--
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]
RE: RE: [PHP-DB] sending bulk emails
Actually, I've been tempted to do that. Never done it, though. But I would
agree with you.
The sense of power would be...euphoric
-Original Message-
From: Trond Erling Hundal [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 7:36 AM
To: [EMAIL PROTECTED]; Rick Emery
Cc: PHP DB list
Subject: SV: RE: [PHP-DB] sending bulk emails
I say. Help those who want to be helped. Or else, don't bother.
And if they complain, format their harddrive.
eh...
Come on guys.. don't you remember the first time you made a
spam-script/newsletter-script??
...the feeling you felt when all those mail streamed out of the server...
it IS special.
Don't ruin this poor guy's experience.
> -Opprinnelig melding-
> Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Pa vegne av Russ
> Michell
> Sendt: 2. november 2001 14:34
> Til: Rick Emery
> Kopi: PHP DB list
> Emne: Re: RE: [PHP-DB] sending bulk emails
>
>
> Hmmm this is true - but as someone once wrote on this list:
>
> "If someone want's to build a car with 4 reverse gears, we can
> tell them it's not a very good idea,
> but we can also show them how to do it."
>
> Granted though - spam is a little different than cars!
> Cheers.
>
> Russ
> On Fri, 2 Nov 2001 07:26:15 -0600 Rick Emery <[EMAIL PROTECTED]> wrote:
>
> > Opswe've just armed a potential spammer...
> >
> > -Original Message-
> > From: Russ Michell [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 02, 2001 6:20 AM
> > To: Cami
> > Cc: PHP DB list
> > Subject: Re: [PHP-DB] sending bulk emails
> >
> >
> > > Does anybody know how to send bulk emails using php?
> > Don't do it!!
> >
> > But of you must - I guess you could build an array containing email
> > addresses, names, etc - taken
> > from form input or a database or whatever and then loop the
> arrays mailing
> > people...
> >
> > $mail = "mail(";
> > for($i=0; $i<$email_array_name;$i++( {
> > $mail .= "$values,";
> > }
> > $mail .= "\"$subject\",\"$body\",\"From: $from\");";
> >
> > Something like that anyway (that's just off the top of my head)
> > Regards.
> >
> > Russ
> >
> > On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
> >
> > > Hi guys,
> > > Does anybody know how to send bulk emails using php?
> > > Thanks,
> > > Cami
> > >
> > > --
> > > 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]
> > >
> >
> > #---#
> >
> > "Believe nothing - consider everything"
> >
> > Russ Michell
> > Anglia Polytechnic University Webteam
> > Room 1C 'The Eastings' East Road, Cambridge
> >
> > e: [EMAIL PROTECTED]
> > w: www.apu.ac.uk/webteam
> >
> > www.theruss.com
> >
> > #---#
> >
> >
> > --
> > 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]
> >
> >
> >
> > --
> > 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]
> >
>
> #---#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
> #---#
>
>
> --
> 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]
>
>
--
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]
RE: [PHP-DB] php-mysql-and the elusive eval statement....
That which is in an evel() must be valid PHP code. "?>" is not PHP, rather
it terminates a PHP segment.
What ARE you trying to execute? I've used eval() with arguments extracted
from a mySQL database many times with success.
-Original Message-
From: Richard A. Noordam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 4:06 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] php-mysql-and the elusive eval statement
I'm having a php/mysql problem using the eval statement. what I'm done is
created a template that is database driven
ie. the document is setup so that all of the head, leftside, body, right
and bottom are all text comming from database query returns.
all database returns are valid tested code. all peices have been tested in
their own pages and shown to work.
inside the text of the returns supposedly can be php code. using the eval
statment i can get the html code to return no problem(page works correctly).
when the code has php code in it it doesn't seem to work.
using the eval statement I should be able to do something like
eval ("?>$string") and it should evaluate the the code within thus when it
comes to a $top");
?>
the inside code just goes out and grabs a counter value, updates it +1 and
returns the original counter val.
I get nothing(well I get a space, where somehthing is suppose to be
returned). the code inside works also as independently in a page by itself
it'll return valid counter information and does the update.
I'm about ready to pull my hair out, (good thing my wife keeps it about 1/2
inch long, heh heh). tie all of my computers together with a big rope and
use them as boat anchors. (I don't even have a boat, so I'll just have
to throw them in)
so any help avoiding this costly situation would be appreciated thanks
in advance
R
---
Never, Never buy beer! Make it! It tastes better!!
Woke up this mornin' an' I had myself a beer.
Yea, Ah woke up this mornin' an' I had myself a beer.
The futures' uncertain and the end is always near.
-Jim Morrison, "Roadhouse Blues"
Fill with mingled cream and amber,
I will drain that glass again.
Such hilarious visions clamber
Through the chambers of my brain.
Quaintest thoughts--queerest fancies,
Come to life and fade away:
I am drinking ale today.
--Edgar Allan Poe
--
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]
--
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]
SV: RE: [PHP-DB] sending bulk emails
I say. Help those who want to be helped. Or else, don't bother.
And if they complain, format their harddrive.
eh...
Come on guys.. don't you remember the first time you made a
spam-script/newsletter-script??
...the feeling you felt when all those mail streamed out of the server...
it IS special.
Don't ruin this poor guy's experience.
> -Opprinnelig melding-
> Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Pa vegne av Russ
> Michell
> Sendt: 2. november 2001 14:34
> Til: Rick Emery
> Kopi: PHP DB list
> Emne: Re: RE: [PHP-DB] sending bulk emails
>
>
> Hmmm this is true - but as someone once wrote on this list:
>
> "If someone want's to build a car with 4 reverse gears, we can
> tell them it's not a very good idea,
> but we can also show them how to do it."
>
> Granted though - spam is a little different than cars!
> Cheers.
>
> Russ
> On Fri, 2 Nov 2001 07:26:15 -0600 Rick Emery <[EMAIL PROTECTED]> wrote:
>
> > Opswe've just armed a potential spammer...
> >
> > -Original Message-
> > From: Russ Michell [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, November 02, 2001 6:20 AM
> > To: Cami
> > Cc: PHP DB list
> > Subject: Re: [PHP-DB] sending bulk emails
> >
> >
> > > Does anybody know how to send bulk emails using php?
> > Don't do it!!
> >
> > But of you must - I guess you could build an array containing email
> > addresses, names, etc - taken
> > from form input or a database or whatever and then loop the
> arrays mailing
> > people...
> >
> > $mail = "mail(";
> > for($i=0; $i<$email_array_name;$i++( {
> > $mail .= "$values,";
> > }
> > $mail .= "\"$subject\",\"$body\",\"From: $from\");";
> >
> > Something like that anyway (that's just off the top of my head)
> > Regards.
> >
> > Russ
> >
> > On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
> >
> > > Hi guys,
> > > Does anybody know how to send bulk emails using php?
> > > Thanks,
> > > Cami
> > >
> > > --
> > > 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]
> > >
> >
> > #---#
> >
> > "Believe nothing - consider everything"
> >
> > Russ Michell
> > Anglia Polytechnic University Webteam
> > Room 1C 'The Eastings' East Road, Cambridge
> >
> > e: [EMAIL PROTECTED]
> > w: www.apu.ac.uk/webteam
> >
> > www.theruss.com
> >
> > #---#
> >
> >
> > --
> > 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]
> >
> >
> >
> > --
> > 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]
> >
>
> #---#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
> #---#
>
>
> --
> 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]
>
>
--
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]
RE: RE: [PHP-DB] sending bulk emails
True...so very true...
A little knowledge is a dangerous thing. In the hands of a spammer...a
deadly thing...
-Original Message-
From: Russ Michell [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 7:34 AM
To: Rick Emery
Cc: PHP DB list
Subject: Re: RE: [PHP-DB] sending bulk emails
Hmmm this is true - but as someone once wrote on this list:
"If someone want's to build a car with 4 reverse gears, we can tell them
it's not a very good idea,
but we can also show them how to do it."
Granted though - spam is a little different than cars!
Cheers.
Russ
On Fri, 2 Nov 2001 07:26:15 -0600 Rick Emery <[EMAIL PROTECTED]> wrote:
> Opswe've just armed a potential spammer...
>
> -Original Message-
> From: Russ Michell [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 02, 2001 6:20 AM
> To: Cami
> Cc: PHP DB list
> Subject: Re: [PHP-DB] sending bulk emails
>
>
> > Does anybody know how to send bulk emails using php?
> Don't do it!!
>
> But of you must - I guess you could build an array containing email
> addresses, names, etc - taken
> from form input or a database or whatever and then loop the arrays mailing
> people...
>
> $mail = "mail(";
> for($i=0; $i<$email_array_name;$i++( {
> $mail .= "$values,";
> }
> $mail .= "\"$subject\",\"$body\",\"From: $from\");";
>
> Something like that anyway (that's just off the top of my head)
> Regards.
>
> Russ
>
> On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
>
> > Hi guys,
> > Does anybody know how to send bulk emails using php?
> > Thanks,
> > Cami
> >
> > --
> > 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]
> >
>
> #---#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
> #---#
>
>
> --
> 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]
>
>
>
> --
> 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]
>
#---#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
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]
Re: RE: [PHP-DB] sending bulk emails
Hmmm this is true - but as someone once wrote on this list:
"If someone want's to build a car with 4 reverse gears, we can tell them it's not a
very good idea,
but we can also show them how to do it."
Granted though - spam is a little different than cars!
Cheers.
Russ
On Fri, 2 Nov 2001 07:26:15 -0600 Rick Emery <[EMAIL PROTECTED]> wrote:
> Opswe've just armed a potential spammer...
>
> -Original Message-
> From: Russ Michell [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 02, 2001 6:20 AM
> To: Cami
> Cc: PHP DB list
> Subject: Re: [PHP-DB] sending bulk emails
>
>
> > Does anybody know how to send bulk emails using php?
> Don't do it!!
>
> But of you must - I guess you could build an array containing email
> addresses, names, etc - taken
> from form input or a database or whatever and then loop the arrays mailing
> people...
>
> $mail = "mail(";
> for($i=0; $i<$email_array_name;$i++( {
> $mail .= "$values,";
> }
> $mail .= "\"$subject\",\"$body\",\"From: $from\");";
>
> Something like that anyway (that's just off the top of my head)
> Regards.
>
> Russ
>
> On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
>
> > Hi guys,
> > Does anybody know how to send bulk emails using php?
> > Thanks,
> > Cami
> >
> > --
> > 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]
> >
>
> #---#
>
> "Believe nothing - consider everything"
>
> Russ Michell
> Anglia Polytechnic University Webteam
> Room 1C 'The Eastings' East Road, Cambridge
>
> e: [EMAIL PROTECTED]
> w: www.apu.ac.uk/webteam
>
> www.theruss.com
>
> #---#
>
>
> --
> 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]
>
>
>
> --
> 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]
>
#---#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
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]
RE: [PHP-DB] Re: Using A Query Results Multiple Times
Easier solution: mysql_data_seek (resource result_identifier, int
row_number)
Example:
$query = "SELECT * FROM mytable";
$result = mysql_query($query) or die("Error: ".mysql_error());
while ($row = mysql_fetch_row($result) )
{
...do some stuff...
}
mysql_data_seek($result, 0 );
while ($row = mysql_fetch_row($result) )
{
...do some other stuff...
}
Thus, you don't have to store it in an array.
-Original Message-
From: Chris Lee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 7:20 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Using A Query Results Multiple Times
just put it in a loop.
while($val = mysql_fetch_result($result))
$array[] = $val;
foreach($count = 0; $count < count($array); $count++)
echo $array[$count]['product_name'];
foreach($count = 0; $count < count($array); $count++)
echo $array[$count]['product_name'];
php4 has foreach() its better, think of upgrading, there are numerous
reasons.
--
Chris Lee
[EMAIL PROTECTED]
"Adam Douglas" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have an instance where I have to query my MySQL database and then
> use the multiple row results to create multiple pull down menus on a web
> page. My problem is how can I take the results of the query and use them
> more the once to create pull down menus? I've always used a while look to
> fetch each row of the results and have it create the pull down menu as it
> goes through each row. But doing it this way only stores one row of
results
> in a variable. Is there a way I can grab all the results from a query that
> would go into an array so I could use it multiple times? I've lookingere
> briefly for a function to MySQL that would allow me to do this but haven't
> found anything unless I misunderstand mysql_fetch_array function. At first
I
> thought I could loop through my while loop and have it put the results
from
> the query of each row in to a multidimensional array. But then how would I
> add to the array after the initial row?
>
> BTW, I'm using PHP 3.0.16 so I can't use the added array functions
that
> PHP 4 has. I do plan on upgrading soon.
>
--
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]
--
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]
RE: [PHP-DB] sending bulk emails
Opswe've just armed a potential spammer...
-Original Message-
From: Russ Michell [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 6:20 AM
To: Cami
Cc: PHP DB list
Subject: Re: [PHP-DB] sending bulk emails
> Does anybody know how to send bulk emails using php?
Don't do it!!
But of you must - I guess you could build an array containing email
addresses, names, etc - taken
from form input or a database or whatever and then loop the arrays mailing
people...
$mail = "mail(";
for($i=0; $i<$email_array_name;$i++( {
$mail .= "$values,";
}
$mail .= "\"$subject\",\"$body\",\"From: $from\");";
Something like that anyway (that's just off the top of my head)
Regards.
Russ
On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
> Hi guys,
> Does anybody know how to send bulk emails using php?
> Thanks,
> Cami
>
> --
> 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]
>
#---#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
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]
--
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]
Re: [PHP-DB] sending bulk emails
> Does anybody know how to send bulk emails using php?
Don't do it!!
But of you must - I guess you could build an array containing email addresses, names,
etc - taken
from form input or a database or whatever and then loop the arrays mailing people...
$mail = "mail(";
for($i=0; $i<$email_array_name;$i++( {
$mail .= "$values,";
}
$mail .= "\"$subject\",\"$body\",\"From: $from\");";
Something like that anyway (that's just off the top of my head)
Regards.
Russ
On Fri, 2 Nov 2001 11:26:22 - Cami <[EMAIL PROTECTED]> wrote:
> Hi guys,
> Does anybody know how to send bulk emails using php?
> Thanks,
> Cami
>
> --
> 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]
>
#---#
"Believe nothing - consider everything"
Russ Michell
Anglia Polytechnic University Webteam
Room 1C 'The Eastings' East Road, Cambridge
e: [EMAIL PROTECTED]
w: www.apu.ac.uk/webteam
www.theruss.com
#---#
--
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]
RE: [PHP-DB] UPDATE table1 FROM table2
Uups! Sorry, That won't work. Do it like this: REPLACE INTO test2 (test2.ID, test2.Value) SELECT test1.ID, test1.Value FROM test1 WHERE test1.ID LIKE '1' >From manual: "...REPLACE works exactly like INSERT, except that if an old record in the table has the same value as a new record on a unique index, the old record is deleted before the new record is inserted" Niklas -Original Message- From: m0sh3 [mailto:[EMAIL PROTECTED]] Sent: 2. marraskuuta 2001 13:37 To: Niklas Lampén Subject: Re: [PHP-DB] UPDATE table1 FROM table2 thanx for reply but in manual there's nothing said about this form of UPDATE, just plain one. your way: how do i link fields between updated table and source table? thanx - Original Message - From: "Niklas Lampén" <[EMAIL PROTECTED]> To: "'m0sh3'" <[EMAIL PROTECTED]> Sent: Friday, November 02, 2001 3:27 AM Subject: RE: [PHP-DB] UPDATE table1 FROM table2 > Yes, it is possible: > > UPDATE TABLE2 SET (Field1, Field2, Field3) > SELECT UpdaterField1, UpdaterField2, UpdaterField3 FROM TABLE1 WHERE > SomeField LIKE 'Something' WHERE SomeField LIKE 'Something' > > > That should work. Manual tells you more in Update section. > > > Niklas > > -Original Message- > From: m0sh3 [mailto:[EMAIL PROTECTED]] > Sent: 2. marraskuuta 2001 13:15 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] UPDATE table1 FROM table2 > > > In MySQL 3.23, how to update one table using information from another > table. > > update table1 set value1=t2.value2 > from table1 as t inner join table2 as t1 using(pk_key) ??? > > or > > update table1 as t1 inner join table2 as t2 using(pk_key) > set t1.value1=t2.value2 ??? > > Is it possible at all? > > Thank you > > > > -- > 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] > > -- 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]
RE: [PHP-DB] UPDATE table1 FROM table2
Yes, it is possible: UPDATE TABLE2 SET (Field1, Field2, Field3) SELECT UpdaterField1, UpdaterField2, UpdaterField3 FROM TABLE1 WHERE SomeField LIKE 'Something' WHERE SomeField LIKE 'Something' That should work. Manual tells you more in Update section. Niklas -Original Message- From: m0sh3 [mailto:[EMAIL PROTECTED]] Sent: 2. marraskuuta 2001 13:15 To: [EMAIL PROTECTED] Subject: [PHP-DB] UPDATE table1 FROM table2 In MySQL 3.23, how to update one table using information from another table. update table1 set value1=t2.value2 from table1 as t inner join table2 as t1 using(pk_key) ??? or update table1 as t1 inner join table2 as t2 using(pk_key) set t1.value1=t2.value2 ??? Is it possible at all? Thank you -- 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] -- 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]
[PHP-DB] sending bulk emails
Hi guys, Does anybody know how to send bulk emails using php? Thanks, Cami -- 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]
[PHP-DB] UPDATE table1 FROM table2
In MySQL 3.23, how to update one table using information from another table. update table1 set value1=t2.value2 from table1 as t inner join table2 as t1 using(pk_key) ??? or update table1 as t1 inner join table2 as t2 using(pk_key) set t1.value1=t2.value2 ??? Is it possible at all? Thank you -- 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]
