Re: [PHP] for loop problem
Try this:
If ($button != "")
{
$t = mysql_query("SELECT * from AddExisting");
$number_of_customers = mysql_num_rows($t);
for($i=0; $i<$number_of_customers;$i++)
{
$r = mysql_fetch_array($t);
$email = $r["EMAIL_ADDRESS"];
$cusname = $r["Name"];
$originalMessage = $message
$to = $email;
$subject = "hello";
$message = "Dear $cusname,".$originalMessage;
$fromaddress = "[EMAIL PROTECTED]";
mail($to, $subject, $message, $fromaddress);
}//end of for
}//end of if
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Kris Vose" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 2:07 PM
Subject: [PHP] for loop problem
I have a problem with a piece of code that uses the mail function in a for
loop. It sends out mail to all the users in the database but it has a
problem with attaching their specific name into the message. What happens
is the first user in the database will get their name in the e-mail (Dear
John,). Then the second user in the database will get the last users name
and their name in the e-mail (Dear John, Dear Mike) ...and so on and so
forth.
How do I fix this problem? Your help is appreciated.
Here is the code:
If ($button != "")
{
$t = mysql_query("SELECT * from AddExisting");
$number_of_customers = mysql_num_rows($t);
for($i=0; $i<$number_of_customers;$i++)
{
$r = mysql_fetch_array($t);
$email = $r["EMAIL_ADDRESS"];
$cusname = $r["Name"];
$to = $email;
$subject = "hello";
$message = "Dear $cusname,".$message;
$fromaddress = "[EMAIL PROTECTED]";
mail($to, $subject, $message, $fromaddress);
}//end of for
}//end of if
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] for loop problem
Opps, last messages had the definition of $originalMessage in the wrong
place. Try this:
If ($button != "")
{
$t = mysql_query("SELECT * from AddExisting");
$number_of_customers = mysql_num_rows($t);
$originalMessage = $message;
for($i=0; $i<$number_of_customers;$i++)
{
$r = mysql_fetch_array($t);
$email = $r["EMAIL_ADDRESS"];
$cusname = $r["Name"];
$to = $email;
$subject = "hello";
$message = "Dear $cusname,".$originalMessage;
$fromaddress = "[EMAIL PROTECTED]";
mail($to, $subject, $message, $fromaddress);
}//end of for
}//end of if
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Kris Vose" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 20, 2002 2:07 PM
Subject: [PHP] for loop problem
I have a problem with a piece of code that uses the mail function in a for
loop. It sends out mail to all the users in the database but it has a
problem with attaching their specific name into the message. What happens
is the first user in the database will get their name in the e-mail (Dear
John,). Then the second user in the database will get the last users name
and their name in the e-mail (Dear John, Dear Mike) ...and so on and so
forth.
How do I fix this problem? Your help is appreciated.
Here is the code:
If ($button != "")
{
$t = mysql_query("SELECT * from AddExisting");
$number_of_customers = mysql_num_rows($t);
for($i=0; $i<$number_of_customers;$i++)
{
$r = mysql_fetch_array($t);
$email = $r["EMAIL_ADDRESS"];
$cusname = $r["Name"];
$to = $email;
$subject = "hello";
$message = "Dear $cusname,".$message;
$fromaddress = "[EMAIL PROTECTED]";
mail($to, $subject, $message, $fromaddress);
}//end of for
}//end of if
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] for loop problem
On Wed, 20 Mar 2002, Kris Vose wrote:
> I have a problem with a piece of code that uses the mail function in a
> for loop. It sends out mail to all the users in the database but it has
> a problem with attaching their specific name into the message. What
> happens is the first user in the database will get their name in the
> e-mail (Dear John,). Then the second user in the database will get the
> last users name and their name in the e-mail (Dear John, Dear Mike)
> ...and so on and so forth.
>
> If ($button != "")
> {
> $t = mysql_query("SELECT * from AddExisting");
> $number_of_customers = mysql_num_rows($t);
>
> for($i=0; $i<$number_of_customers;$i++)
> {
> $r = mysql_fetch_array($t);
> $email = $r["EMAIL_ADDRESS"];
> $cusname = $r["Name"];
>
> $to = $email;
> $subject = "hello";
> $message = "Dear $cusname,".$message;
> $fromaddress = "[EMAIL PROTECTED]";
>
> mail($to, $subject, $message, $fromaddress);
> }//end of for
> }//end of if
You don't need a for loop here; you don't actually care specifically how
many customers there are, just that you iterate once for each one. And
you've put a raw email address in the "extra headers" argument to mail()
rather than a properly-formed From: header.
Here's the code you want:
if (!empty(button))
{
$t = mysql_query("SELECT * from AddExisting");
while ($r = mysql_fetch_assoc($t))
{
$message = "Dear {$r[name]},\n{$message}";
mail ($r[email_address], 'hello', $message, 'From: [EMAIL PROTECTED]');
}
}
miguel
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] for loop problem?
try removing the quotes and see if that works
eg
$value1 = "100";
becomes
$value1 = 100;
and
for($i="$value1"; $i<="$value2"; $i++) {
becomes
for($i=$value1; $i<=$value2; $i++) {
Martin T
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 2:33 PM
To: PHP-General
Subject: [PHP] for loop problem?
Hello everyone,
I have a pretty big list of codes that need to be put into a mysql db. The
numbers range from 100 to 1223109. Here's the PHP I wrote to put these
codes into a database:
".mysql_error()."";
exit;
}
}
mysql_close($connection);
?>
Everytime I run this from a browser, it just keeps looping. It should put
about 223109 entries into the "passcodes" table. However, it just keeps
looping. I'll end up with 400,000 or so entries before I stop it. I make
sure I empty that table before I start running it again. Why is this
happening?
Thanks everyone,
Tyler
--
PHP General 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] for loop problem?
My word why all the quotes?
".mysql_error()."";
exit;
}
}
mysql_close($connection);
?>
That should give you some better results.
On Monday 12 November 2001 07:32 pm, you wrote:
> Hello everyone,
>
> I have a pretty big list of codes that need to be put into a mysql db. The
> numbers range from 100 to 1223109. Here's the PHP I wrote to put these
> codes into a database:
>
> $connection = mysql_connect("blah","blah","blah");
> $db = mysql_select_db("db_to_use", $connection);
> $value1 = "100";
> $value2 = "1223109";
> for($i="$value1"; $i<="$value2"; $i++) {
> mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> if (mysql_error() != "") {
> print "".mysql_error()."";
> exit;
> }
> }
> mysql_close($connection);
> ?>
>
> Everytime I run this from a browser, it just keeps looping. It should put
> about 223109 entries into the "passcodes" table. However, it just keeps
> looping. I'll end up with 400,000 or so entries before I stop it. I make
> sure I empty that table before I start running it again. Why is this
> happening?
>
> Thanks everyone,
> Tyler
--
PHP General 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] for loop problem?
To everyone that said it had something to do with the quotes:
that has nothing to do with it.
When I first wrote this, It didn't have all the quotes. It did the same
thing. Then, I thought I may need some quotes somewhere, but that obviously
didn't help. Any other suggestions? If I HAVE to, I'll do this in PERL,
but would much rather do it in PHP.
Thanks everyone,
Tyler
- Original Message -
From: "Evan Nemerson" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 9:41 PM
Subject: Re: [PHP] for loop problem?
> My word why all the quotes?
>
> $connection = mysql_connect("blah","blah","blah");
> $db = mysql_select_db("db_to_use", $connection);
> $value1 = 100;
> $value2 = 1223109;
> for($i=$value1; $i<=$value2; $i++) {
> mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> if (mysql_error() != "") {
> print "".mysql_error()."";
> exit;
> }
> }
> mysql_close($connection);
> ?>
>
> That should give you some better results.
>
>
> On Monday 12 November 2001 07:32 pm, you wrote:
> > Hello everyone,
> >
> > I have a pretty big list of codes that need to be put into a mysql db.
The
> > numbers range from 100 to 1223109. Here's the PHP I wrote to put
these
> > codes into a database:
> >
> > > $connection = mysql_connect("blah","blah","blah");
> > $db = mysql_select_db("db_to_use", $connection);
> > $value1 = "100";
> > $value2 = "1223109";
> > for($i="$value1"; $i<="$value2"; $i++) {
> > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > if (mysql_error() != "") {
> > print "".mysql_error()."";
> > exit;
> > }
> > }
> > mysql_close($connection);
> > ?>
> >
> > Everytime I run this from a browser, it just keeps looping. It should
put
> > about 223109 entries into the "passcodes" table. However, it just keeps
> > looping. I'll end up with 400,000 or so entries before I stop it. I
make
> > sure I empty that table before I start running it again. Why is this
> > happening?
> >
> > Thanks everyone,
> > Tyler
>
> --
> PHP General 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 General 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] for loop problem?
hmmm... I just tried :
$value1 = 100;
$value2 = 1223109;
for($i = $value1; $i <= $value2; $i++)
{
echo "$i\n";
}
and it spat out all 223109 numbers (albiet after a VERY long time)
can't see how adding mysql code would affect the loop...
Martin T
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 2:53 PM
To: Evan Nemerson; [EMAIL PROTECTED]
Subject: Re: [PHP] for loop problem?
To everyone that said it had something to do with the quotes:
that has nothing to do with it.
When I first wrote this, It didn't have all the quotes. It did the same
thing. Then, I thought I may need some quotes somewhere, but that obviously
didn't help. Any other suggestions? If I HAVE to, I'll do this in PERL,
but would much rather do it in PHP.
Thanks everyone,
Tyler
- Original Message -
From: "Evan Nemerson" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 9:41 PM
Subject: Re: [PHP] for loop problem?
> My word why all the quotes?
>
> $connection = mysql_connect("blah","blah","blah");
> $db = mysql_select_db("db_to_use", $connection);
> $value1 = 100;
> $value2 = 1223109;
> for($i=$value1; $i<=$value2; $i++) {
> mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> if (mysql_error() != "") {
> print "".mysql_error()."";
> exit;
> }
> }
> mysql_close($connection);
> ?>
>
> That should give you some better results.
>
>
> On Monday 12 November 2001 07:32 pm, you wrote:
> > Hello everyone,
> >
> > I have a pretty big list of codes that need to be put into a mysql db.
The
> > numbers range from 100 to 1223109. Here's the PHP I wrote to put
these
> > codes into a database:
> >
> > > $connection = mysql_connect("blah","blah","blah");
> > $db = mysql_select_db("db_to_use", $connection);
> > $value1 = "100";
> > $value2 = "1223109";
> > for($i="$value1"; $i<="$value2"; $i++) {
> > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > if (mysql_error() != "") {
> > print "".mysql_error()."";
> > exit;
> > }
> > }
> > mysql_close($connection);
> > ?>
> >
> > Everytime I run this from a browser, it just keeps looping. It should
put
> > about 223109 entries into the "passcodes" table. However, it just keeps
> > looping. I'll end up with 400,000 or so entries before I stop it. I
make
> > sure I empty that table before I start running it again. Why is this
> > happening?
> >
> > Thanks everyone,
> > Tyler
>
> --
> PHP General 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 General 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] for loop problem?
I removed all of the quotes that could be affecting it. Still, it loops
until I stop it. I let it go all the way up to 350,000 or so. Any other
ideas anyone?
Thank you!
Tyler
- Original Message -
From: "Martin Towell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 10:06 PM
Subject: RE: [PHP] for loop problem?
> hmmm... I just tried :
>
> $value1 = 100;
> $value2 = 1223109;
> for($i = $value1; $i <= $value2; $i++)
> {
> echo "$i\n";
> }
>
> and it spat out all 223109 numbers (albiet after a VERY long time)
> can't see how adding mysql code would affect the loop...
>
> Martin T
>
> -Original Message-
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 13, 2001 2:53 PM
> To: Evan Nemerson; [EMAIL PROTECTED]
> Subject: Re: [PHP] for loop problem?
>
>
> To everyone that said it had something to do with the quotes:
> that has nothing to do with it.
>
> When I first wrote this, It didn't have all the quotes. It did the same
> thing. Then, I thought I may need some quotes somewhere, but that
obviously
> didn't help. Any other suggestions? If I HAVE to, I'll do this in PERL,
> but would much rather do it in PHP.
>
> Thanks everyone,
> Tyler
>
> - Original Message -
> From: "Evan Nemerson" <[EMAIL PROTECTED]>
> To: "Tyler Longren" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, November 12, 2001 9:41 PM
> Subject: Re: [PHP] for loop problem?
>
>
> > My word why all the quotes?
> >
> > > $connection = mysql_connect("blah","blah","blah");
> > $db = mysql_select_db("db_to_use", $connection);
> > $value1 = 100;
> > $value2 = 1223109;
> > for($i=$value1; $i<=$value2; $i++) {
> > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > if (mysql_error() != "") {
> > print "".mysql_error()."";
> > exit;
> > }
> > }
> > mysql_close($connection);
> > ?>
> >
> > That should give you some better results.
> >
> >
> > On Monday 12 November 2001 07:32 pm, you wrote:
> > > Hello everyone,
> > >
> > > I have a pretty big list of codes that need to be put into a mysql db.
> The
> > > numbers range from 100 to 1223109. Here's the PHP I wrote to put
> these
> > > codes into a database:
> > >
> > > > > $connection = mysql_connect("blah","blah","blah");
> > > $db = mysql_select_db("db_to_use", $connection);
> > > $value1 = "100";
> > > $value2 = "1223109";
> > > for($i="$value1"; $i<="$value2"; $i++) {
> > > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > > if (mysql_error() != "") {
> > > print "".mysql_error()."";
> > > exit;
> > > }
> > > }
> > > mysql_close($connection);
> > > ?>
> > >
> > > Everytime I run this from a browser, it just keeps looping. It should
> put
> > > about 223109 entries into the "passcodes" table. However, it just
keeps
> > > looping. I'll end up with 400,000 or so entries before I stop it. I
> make
> > > sure I empty that table before I start running it again. Why is this
> > > happening?
> > >
> > > Thanks everyone,
> > > Tyler
> >
> > --
> > PHP General 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 General 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 General 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] for loop problem?
paste the complete code in and myself and others can run your exact copy
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 11:22 PM
To: Martin Towell; [EMAIL PROTECTED]
Subject: Re: [PHP] for loop problem?
I removed all of the quotes that could be affecting it. Still, it loops
until I stop it. I let it go all the way up to 350,000 or so. Any other
ideas anyone?
Thank you!
Tyler
- Original Message -
From: "Martin Towell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 10:06 PM
Subject: RE: [PHP] for loop problem?
> hmmm... I just tried :
>
> $value1 = 100;
> $value2 = 1223109;
> for($i = $value1; $i <= $value2; $i++)
> {
> echo "$i\n";
> }
>
> and it spat out all 223109 numbers (albiet after a VERY long time)
> can't see how adding mysql code would affect the loop...
>
> Martin T
>
> -Original Message-
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 13, 2001 2:53 PM
> To: Evan Nemerson; [EMAIL PROTECTED]
> Subject: Re: [PHP] for loop problem?
>
>
> To everyone that said it had something to do with the quotes:
> that has nothing to do with it.
>
> When I first wrote this, It didn't have all the quotes. It did the same
> thing. Then, I thought I may need some quotes somewhere, but that
obviously
> didn't help. Any other suggestions? If I HAVE to, I'll do this in PERL,
> but would much rather do it in PHP.
>
> Thanks everyone,
> Tyler
>
> - Original Message -
> From: "Evan Nemerson" <[EMAIL PROTECTED]>
> To: "Tyler Longren" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, November 12, 2001 9:41 PM
> Subject: Re: [PHP] for loop problem?
>
>
> > My word why all the quotes?
> >
> > > $connection = mysql_connect("blah","blah","blah");
> > $db = mysql_select_db("db_to_use", $connection);
> > $value1 = 100;
> > $value2 = 1223109;
> > for($i=$value1; $i<=$value2; $i++) {
> > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > if (mysql_error() != "") {
> > print "".mysql_error()."";
> > exit;
> > }
> > }
> > mysql_close($connection);
> > ?>
> >
> > That should give you some better results.
> >
> >
> > On Monday 12 November 2001 07:32 pm, you wrote:
> > > Hello everyone,
> > >
> > > I have a pretty big list of codes that need to be put into a mysql db.
> The
> > > numbers range from 100 to 1223109. Here's the PHP I wrote to put
> these
> > > codes into a database:
> > >
> > > > > $connection = mysql_connect("blah","blah","blah");
> > > $db = mysql_select_db("db_to_use", $connection);
> > > $value1 = "100";
> > > $value2 = "1223109";
> > > for($i="$value1"; $i<="$value2"; $i++) {
> > > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > > if (mysql_error() != "") {
> > > print "".mysql_error()."";
> > > exit;
> > > }
> > > }
> > > mysql_close($connection);
> > > ?>
> > >
> > > Everytime I run this from a browser, it just keeps looping. It should
> put
> > > about 223109 entries into the "passcodes" table. However, it just
keeps
> > > looping. I'll end up with 400,000 or so entries before I stop it. I
> make
> > > sure I empty that table before I start running it again. Why is this
> > > happening?
> > >
> > > Thanks everyone,
> > > Tyler
> >
> > --
> > PHP General 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 General 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 General 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 General 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] for loop problem?
Exact code:
".mysql_error()."";
exit;
}
}
mysql_close($connection);
?>
Tyler
- Original Message -
From: "Jack Dempsey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 10:34 PM
Subject: RE: [PHP] for loop problem?
> paste the complete code in and myself and others can run your exact copy
>
> -Original Message-
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 11:22 PM
> To: Martin Towell; [EMAIL PROTECTED]
> Subject: Re: [PHP] for loop problem?
>
>
> I removed all of the quotes that could be affecting it. Still, it loops
> until I stop it. I let it go all the way up to 350,000 or so. Any other
> ideas anyone?
>
> Thank you!
> Tyler
>
> - Original Message -
> From: "Martin Towell" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, November 12, 2001 10:06 PM
> Subject: RE: [PHP] for loop problem?
>
>
> > hmmm... I just tried :
> >
> > $value1 = 100;
> > $value2 = 1223109;
> > for($i = $value1; $i <= $value2; $i++)
> > {
> > echo "$i\n";
> > }
> >
> > and it spat out all 223109 numbers (albiet after a VERY long time)
> > can't see how adding mysql code would affect the loop...
> >
> > Martin T
> >
> > -Original Message-
> > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 13, 2001 2:53 PM
> > To: Evan Nemerson; [EMAIL PROTECTED]
> > Subject: Re: [PHP] for loop problem?
> >
> >
> > To everyone that said it had something to do with the quotes:
> > that has nothing to do with it.
> >
> > When I first wrote this, It didn't have all the quotes. It did the same
> > thing. Then, I thought I may need some quotes somewhere, but that
> obviously
> > didn't help. Any other suggestions? If I HAVE to, I'll do this in
PERL,
> > but would much rather do it in PHP.
> >
> > Thanks everyone,
> > Tyler
> >
> > - Original Message -
> > From: "Evan Nemerson" <[EMAIL PROTECTED]>
> > To: "Tyler Longren" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Monday, November 12, 2001 9:41 PM
> > Subject: Re: [PHP] for loop problem?
> >
> >
> > > My word why all the quotes?
> > >
> > > > > $connection = mysql_connect("blah","blah","blah");
> > > $db = mysql_select_db("db_to_use", $connection);
> > > $value1 = 100;
> > > $value2 = 1223109;
> > > for($i=$value1; $i<=$value2; $i++) {
> > > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > > if (mysql_error() != "") {
> > > print "".mysql_error()."";
> > > exit;
> > > }
> > > }
> > > mysql_close($connection);
> > > ?>
> > >
> > > That should give you some better results.
> > >
> > >
> > > On Monday 12 November 2001 07:32 pm, you wrote:
> > > > Hello everyone,
> > > >
> > > > I have a pretty big list of codes that need to be put into a mysql
db.
> > The
> > > > numbers range from 100 to 1223109. Here's the PHP I wrote to
put
> > these
> > > > codes into a database:
> > > >
> > > > > > > $connection = mysql_connect("blah","blah","blah");
> > > > $db = mysql_select_db("db_to_use", $connection);
> > > > $value1 = "100";
> > > > $value2 = "1223109";
> > > > for($i="$value1"; $i<="$value2"; $i++) {
> > > > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > > > if (mysql_error() != "") {
> > > > print "".mysql_error()."";
> > > > exit;
> > > > }
> > > > }
> > > > mysql_close($connection);
> > > > ?>
> > > >
> > > > Everytime I run this from a browser, it just keeps looping. It
should
> > put
> > > > about 223109 entries into the "passcodes" table. However, it just
> keeps
> > > > looping. I'll end up with 400,000 or so entries before I stop it.
I
> > make
> > > > sure I empty that table before I start running it again. Why is
this
> > > > happening?
> > > >
> > > > Thanks everyone,
> > > > Tyler
> > >
> > > --
> > > PHP General 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 General 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 General 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 General 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 General 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] for loop problem?
ran it (without mysql queries) and worked finereal strange.
have you tried the loop without the mysql queries?
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 12, 2001 11:28 PM
To: Jack Dempsey; [EMAIL PROTECTED]
Subject: Re: [PHP] for loop problem?
Exact code:
".mysql_error()."";
exit;
}
}
mysql_close($connection);
?>
Tyler
- Original Message -
From: "Jack Dempsey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 10:34 PM
Subject: RE: [PHP] for loop problem?
> paste the complete code in and myself and others can run your exact copy
>
> -Original Message-
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 11:22 PM
> To: Martin Towell; [EMAIL PROTECTED]
> Subject: Re: [PHP] for loop problem?
>
>
> I removed all of the quotes that could be affecting it. Still, it loops
> until I stop it. I let it go all the way up to 350,000 or so. Any other
> ideas anyone?
>
> Thank you!
> Tyler
>
> - Original Message -
> From: "Martin Towell" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, November 12, 2001 10:06 PM
> Subject: RE: [PHP] for loop problem?
>
>
> > hmmm... I just tried :
> >
> > $value1 = 100;
> > $value2 = 1223109;
> > for($i = $value1; $i <= $value2; $i++)
> > {
> > echo "$i\n";
> > }
> >
> > and it spat out all 223109 numbers (albiet after a VERY long time)
> > can't see how adding mysql code would affect the loop...
> >
> > Martin T
> >
> > -Original Message-
> > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, November 13, 2001 2:53 PM
> > To: Evan Nemerson; [EMAIL PROTECTED]
> > Subject: Re: [PHP] for loop problem?
> >
> >
> > To everyone that said it had something to do with the quotes:
> > that has nothing to do with it.
> >
> > When I first wrote this, It didn't have all the quotes. It did the same
> > thing. Then, I thought I may need some quotes somewhere, but that
> obviously
> > didn't help. Any other suggestions? If I HAVE to, I'll do this in
PERL,
> > but would much rather do it in PHP.
> >
> > Thanks everyone,
> > Tyler
> >
> > - Original Message -
> > From: "Evan Nemerson" <[EMAIL PROTECTED]>
> > To: "Tyler Longren" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Monday, November 12, 2001 9:41 PM
> > Subject: Re: [PHP] for loop problem?
> >
> >
> > > My word why all the quotes?
> > >
> > > > > $connection = mysql_connect("blah","blah","blah");
> > > $db = mysql_select_db("db_to_use", $connection);
> > > $value1 = 100;
> > > $value2 = 1223109;
> > > for($i=$value1; $i<=$value2; $i++) {
> > > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > > if (mysql_error() != "") {
> > > print "".mysql_error()."";
> > > exit;
> > > }
> > > }
> > > mysql_close($connection);
> > > ?>
> > >
> > > That should give you some better results.
> > >
> > >
> > > On Monday 12 November 2001 07:32 pm, you wrote:
> > > > Hello everyone,
> > > >
> > > > I have a pretty big list of codes that need to be put into a mysql
db.
> > The
> > > > numbers range from 100 to 1223109. Here's the PHP I wrote to
put
> > these
> > > > codes into a database:
> > > >
> > > > > > > $connection = mysql_connect("blah","blah","blah");
> > > > $db = mysql_select_db("db_to_use", $connection);
> > > > $value1 = "100";
> > > > $value2 = "1223109";
> > > > for($i="$value1"; $i<="$value2"; $i++) {
> > > > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > > > if (mysql_error() != "") {
> > > > print "".mysql_error()."";
> > > > exit;
> > > > }
> > > > }
> > > > mysql_close($connection);
> > > > ?>
> > > >
> > > > Everytime I run this from a browser, it just keeps looping. It
should
> > put
> > > > about 223109 entries into the "passcodes
Re: [PHP] for loop problem?
I've ran it a few times without the MySQL code in there. Runs just fine
that way for me too. After it's run a few times for me (with the MySQL
code), I start getting duplicate entries of codes in there. For example,
I'll end up with a few 'P100' entries in the 'passcodes' field.
Oh well, here I come perl!
Thanks,
Tyler
- Original Message -
From: "Jack Dempsey" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 10:43 PM
Subject: RE: [PHP] for loop problem?
> ran it (without mysql queries) and worked finereal strange.
> have you tried the loop without the mysql queries?
>
> -Original Message-
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 11:28 PM
> To: Jack Dempsey; [EMAIL PROTECTED]
> Subject: Re: [PHP] for loop problem?
>
>
> Exact code:
> $connection = mysql_connect("host_here","user_here","pass_here");
> $db = mysql_select_db("db_here", $connection);
> $value1 = 100;
> $value2 = 1223109;
> for($i=$value1; $i<=$value2; $i++) {
> mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> if (mysql_error() != "") {
> print "".mysql_error()."";
> exit;
> }
> }
> mysql_close($connection);
> ?>
>
> Tyler
>
> - Original Message -
> From: "Jack Dempsey" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, November 12, 2001 10:34 PM
> Subject: RE: [PHP] for loop problem?
>
>
> > paste the complete code in and myself and others can run your exact copy
> >
> > -Original Message-
> > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 12, 2001 11:22 PM
> > To: Martin Towell; [EMAIL PROTECTED]
> > Subject: Re: [PHP] for loop problem?
> >
> >
> > I removed all of the quotes that could be affecting it. Still, it loops
> > until I stop it. I let it go all the way up to 350,000 or so. Any
other
> > ideas anyone?
> >
> > Thank you!
> > Tyler
> >
> > - Original Message -
> > From: "Martin Towell" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, November 12, 2001 10:06 PM
> > Subject: RE: [PHP] for loop problem?
> >
> >
> > > hmmm... I just tried :
> > >
> > > $value1 = 1000000;
> > > $value2 = 1223109;
> > > for($i = $value1; $i <= $value2; $i++)
> > > {
> > > echo "$i\n";
> > > }
> > >
> > > and it spat out all 223109 numbers (albiet after a VERY long time)
> > > can't see how adding mysql code would affect the loop...
> > >
> > > Martin T
> > >
> > > -Original Message-
> > > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, November 13, 2001 2:53 PM
> > > To: Evan Nemerson; [EMAIL PROTECTED]
> > > Subject: Re: [PHP] for loop problem?
> > >
> > >
> > > To everyone that said it had something to do with the quotes:
> > > that has nothing to do with it.
> > >
> > > When I first wrote this, It didn't have all the quotes. It did the
same
> > > thing. Then, I thought I may need some quotes somewhere, but that
> > obviously
> > > didn't help. Any other suggestions? If I HAVE to, I'll do this in
> PERL,
> > > but would much rather do it in PHP.
> > >
> > > Thanks everyone,
> > > Tyler
> > >
> > > - Original Message -
> > > From: "Evan Nemerson" <[EMAIL PROTECTED]>
> > > To: "Tyler Longren" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
> > > Sent: Monday, November 12, 2001 9:41 PM
> > > Subject: Re: [PHP] for loop problem?
> > >
> > >
> > > > My word why all the quotes?
> > > >
> > > > > > > $connection = mysql_connect("blah","blah","blah");
> > > > $db = mysql_select_db("db_to_use", $connection);
> > > > $value1 = 100;
> > > > $value2 = 1223109;
> > > > for($i=$value1; $i<=$value2; $i++) {
> > > > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > > > if (mysql_error() != "") {
> > > > print "".mysql_error()."";
> > > > exit;
> > > >
RE: [PHP] for loop problem?
How about changing the logic lightly? try this:
$value1 = 0;
$value2 = 223109;
for($i=$value1; $i<=$value2; $i++) {
$tmp = sprintf("1%06d\n", $i);
mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$tmp')");
basically taking away 1,000,000 from the numbers then adding it back on
later
Martin T
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 3:38 PM
To: Jack Dempsey
Cc: PHP-General
Subject: Re: [PHP] for loop problem?
I've ran it a few times without the MySQL code in there. Runs just fine
that way for me too. After it's run a few times for me (with the MySQL
code), I start getting duplicate entries of codes in there. For example,
I'll end up with a few 'P100' entries in the 'passcodes' field.
Oh well, here I come perl!
Thanks,
Tyler
- Original Message -
From: "Jack Dempsey" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 10:43 PM
Subject: RE: [PHP] for loop problem?
> ran it (without mysql queries) and worked finereal strange.
> have you tried the loop without the mysql queries?
>
> -Original Message-
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 12, 2001 11:28 PM
> To: Jack Dempsey; [EMAIL PROTECTED]
> Subject: Re: [PHP] for loop problem?
>
>
> Exact code:
> $connection = mysql_connect("host_here","user_here","pass_here");
> $db = mysql_select_db("db_here", $connection);
> $value1 = 100;
> $value2 = 1223109;
> for($i=$value1; $i<=$value2; $i++) {
> mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> if (mysql_error() != "") {
> print "".mysql_error()."";
> exit;
> }
> }
> mysql_close($connection);
> ?>
>
> Tyler
>
> - Original Message -
> From: "Jack Dempsey" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, November 12, 2001 10:34 PM
> Subject: RE: [PHP] for loop problem?
>
>
> > paste the complete code in and myself and others can run your exact copy
> >
> > -Original Message-
> > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 12, 2001 11:22 PM
> > To: Martin Towell; [EMAIL PROTECTED]
> > Subject: Re: [PHP] for loop problem?
> >
> >
> > I removed all of the quotes that could be affecting it. Still, it loops
> > until I stop it. I let it go all the way up to 350,000 or so. Any
other
> > ideas anyone?
> >
> > Thank you!
> > Tyler
> >
> > - Original Message -
> > From: "Martin Towell" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, November 12, 2001 10:06 PM
> > Subject: RE: [PHP] for loop problem?
> >
> >
> > > hmmm... I just tried :
> > >
> > > $value1 = 100;
> > > $value2 = 1223109;
> > > for($i = $value1; $i <= $value2; $i++)
> > > {
> > > echo "$i\n";
> > > }
> > >
> > > and it spat out all 223109 numbers (albiet after a VERY long time)
> > > can't see how adding mysql code would affect the loop...
> > >
> > > Martin T
> > >
> > > -Original Message-
> > > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, November 13, 2001 2:53 PM
> > > To: Evan Nemerson; [EMAIL PROTECTED]
> > > Subject: Re: [PHP] for loop problem?
> > >
> > >
> > > To everyone that said it had something to do with the quotes:
> > > that has nothing to do with it.
> > >
> > > When I first wrote this, It didn't have all the quotes. It did the
same
> > > thing. Then, I thought I may need some quotes somewhere, but that
> > obviously
> > > didn't help. Any other suggestions? If I HAVE to, I'll do this in
> PERL,
> > > but would much rather do it in PHP.
> > >
> > > Thanks everyone,
> > > Tyler
> > >
> > > - Original Message -
> > > From: "Evan Nemerson" <[EMAIL PROTECTED]>
> > > To: "Tyler Longren" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
> > > Sent: Monday, November 12, 2001 9:41 PM
> > > Subject: Re: [PHP] for loop problem?
> > >
> > >
> > > > My word why all the quotes?
> > > >
> > > > > > > $connection = mysql_connect("blah",&
Re: [PHP] for loop problem?
Hi Martin,
I just got done doing that, and i got the same thing! :-(
Here's something interesting though. There's an id field that's set to
AUTO_INCREMENT. I did a "SELECT * FROM passcodes WHERE passcode='P100'"
This gave me this:
id | passcode
---
1 |P100
82145 |P100
209398 |P100
Shouldn't the ID's be further apart than that? Know what I'm saying?
Tyler
- Original Message -
From: "Martin Towell" <[EMAIL PROTECTED]>
To: "'Tyler Longren'" <[EMAIL PROTECTED]>; "Jack Dempsey"
<[EMAIL PROTECTED]>
Cc: "PHP-General" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 10:45 PM
Subject: RE: [PHP] for loop problem?
> How about changing the logic lightly? try this:
>
> $value1 = 0;
> $value2 = 223109;
> for($i=$value1; $i<=$value2; $i++) {
> $tmp = sprintf("1%06d\n", $i);
> mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$tmp')");
>
> basically taking away 1,000,000 from the numbers then adding it back on
> later
>
> Martin T
>
> -Original Message-
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 13, 2001 3:38 PM
> To: Jack Dempsey
> Cc: PHP-General
> Subject: Re: [PHP] for loop problem?
>
>
> I've ran it a few times without the MySQL code in there. Runs just fine
> that way for me too. After it's run a few times for me (with the MySQL
> code), I start getting duplicate entries of codes in there. For example,
> I'll end up with a few 'P100' entries in the 'passcodes' field.
>
> Oh well, here I come perl!
>
> Thanks,
> Tyler
>
> - Original Message -
> From: "Jack Dempsey" <[EMAIL PROTECTED]>
> To: "Tyler Longren" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, November 12, 2001 10:43 PM
> Subject: RE: [PHP] for loop problem?
>
>
> > ran it (without mysql queries) and worked finereal strange.
> > have you tried the loop without the mysql queries?
> >
> > -Original Message-
> > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, November 12, 2001 11:28 PM
> > To: Jack Dempsey; [EMAIL PROTECTED]
> > Subject: Re: [PHP] for loop problem?
> >
> >
> > Exact code:
> > > $connection = mysql_connect("host_here","user_here","pass_here");
> > $db = mysql_select_db("db_here", $connection);
> > $value1 = 100;
> > $value2 = 1223109;
> > for($i=$value1; $i<=$value2; $i++) {
> > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > if (mysql_error() != "") {
> > print "".mysql_error()."";
> > exit;
> > }
> > }
> > mysql_close($connection);
> > ?>
> >
> > Tyler
> >
> > - Original Message -
> > From: "Jack Dempsey" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, November 12, 2001 10:34 PM
> > Subject: RE: [PHP] for loop problem?
> >
> >
> > > paste the complete code in and myself and others can run your exact
copy
> > >
> > > -Original Message-
> > > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, November 12, 2001 11:22 PM
> > > To: Martin Towell; [EMAIL PROTECTED]
> > > Subject: Re: [PHP] for loop problem?
> > >
> > >
> > > I removed all of the quotes that could be affecting it. Still, it
loops
> > > until I stop it. I let it go all the way up to 350,000 or so. Any
> other
> > > ideas anyone?
> > >
> > > Thank you!
> > > Tyler
> > >
> > > - Original Message -
> > > From: "Martin Towell" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Monday, November 12, 2001 10:06 PM
> > > Subject: RE: [PHP] for loop problem?
> > >
> > >
> > > > hmmm... I just tried :
> > > >
> > > > $value1 = 100;
> > > > $value2 = 1223109;
> > > > for($i = $value1; $i <= $value2; $i++)
> > > > {
> > > > echo "$i\n";
> > > > }
> > > >
> > > > and it spat out all 223109 numbers (albiet after a VERY long time)
> > > > can't see how adding mysql code would affect the loop...
> > > >
> > > > Martin T
> > > &
Re: [PHP] for loop problem?
Hi Tyler,
This doesn't sound like a problem with PHP, but MySQL. Can you show your CREATE
TABLE and MySQL version?
John
>Hi Martin,
>
>I just got done doing that, and i got the same thing! :-(
>
>Here's something interesting though. There's an id field that's set to
>AUTO_INCREMENT. I did a "SELECT * FROM passcodes WHERE passcode='P100'"
>This gave me this:
>
>id | passcode
>---
>1 |P100
>82145 |P100
>209398 |P100
>
>Shouldn't the ID's be further apart than that? Know what I'm saying?
>
>Tyler
>
>- Original Message -
>From: "Martin Towell" <[EMAIL PROTECTED]>
>To: "'Tyler Longren'" <[EMAIL PROTECTED]>; "Jack Dempsey"
><[EMAIL PROTECTED]>
>Cc: "PHP-General" <[EMAIL PROTECTED]>
>Sent: Monday, November 12, 2001 10:45 PM
>Subject: RE: [PHP] for loop problem?
>
>
>> How about changing the logic lightly? try this:
>>
>> $value1 = 0;
>> $value2 = 223109;
>> for($i=$value1; $i<=$value2; $i++) {
>> $tmp = sprintf("1%06d\n", $i);
>> mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$tmp')");
>>
>> basically taking away 1,000,000 from the numbers then adding it back on
>> later
>>
>> Martin T
>>
>> -Original Message-
>> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, November 13, 2001 3:38 PM
>> To: Jack Dempsey
>> Cc: PHP-General
>> Subject: Re: [PHP] for loop problem?
>>
>>
>> I've ran it a few times without the MySQL code in there. Runs just fine
>> that way for me too. After it's run a few times for me (with the MySQL
>> code), I start getting duplicate entries of codes in there. For example,
>> I'll end up with a few 'P100' entries in the 'passcodes' field.
>>
>> Oh well, here I come perl!
>>
>> Thanks,
>> Tyler
>>
>> - Original Message -
>> From: "Jack Dempsey" <[EMAIL PROTECTED]>
>> To: "Tyler Longren" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>> Sent: Monday, November 12, 2001 10:43 PM
>> Subject: RE: [PHP] for loop problem?
>>
>>
>> > ran it (without mysql queries) and worked finereal strange.
>> > have you tried the loop without the mysql queries?
>> >
>> > -Original Message-
>> > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
>> > Sent: Monday, November 12, 2001 11:28 PM
>> > To: Jack Dempsey; [EMAIL PROTECTED]
>> > Subject: Re: [PHP] for loop problem?
>> >
>> >
>> > Exact code:
>> > > > $connection = mysql_connect("host_here","user_here","pass_here");
>> > $db = mysql_select_db("db_here", $connection);
>> > $value1 = 100;
>> > $value2 = 1223109;
>> > for($i=$value1; $i<=$value2; $i++) {
>> > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
>> > if (mysql_error() != "") {
>> > print "".mysql_error()."";
>> > exit;
>> > }
>> > }
>> > mysql_close($connection);
>> > ?>
>> >
>> > Tyler
>> >
>> > - Original Message -
>> > From: "Jack Dempsey" <[EMAIL PROTECTED]>
>> > To: <[EMAIL PROTECTED]>
>> > Sent: Monday, November 12, 2001 10:34 PM
>> > Subject: RE: [PHP] for loop problem?
>> >
>> >
>> > > paste the complete code in and myself and others can run your exact
>copy
>> > >
>> > > -Original Message-
>> > > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
>> > > Sent: Monday, November 12, 2001 11:22 PM
>> > > To: Martin Towell; [EMAIL PROTECTED]
>> > > Subject: Re: [PHP] for loop problem?
>> > >
>> > >
>> > > I removed all of the quotes that could be affecting it. Still, it
>loops
>> > > until I stop it. I let it go all the way up to 350,000 or so. Any
>> other
>> > > ideas anyone?
>> > >
>> > > Thank you!
>> > > Tyler
>> > >
>> > > - Original Message -
>> > > From: "Martin Towell" <[EMAIL PROTECTED]>
>> > > To: <[EMAIL PROTECTED]>
>> > > Sent: Monday, November 12, 2001 10:06 PM
>>
Re: [PHP] for loop problem?
Hi John,
MySQL Version: MySQL 3.23.44-nt
SQL:
CREATE TABLE passcodes (
id int(11) NOT NULL auto_increment,
passcode varchar(255) NOT NULL default '',
PRIMARY KEY (id),
KEY id (id,passcode)
) TYPE=MyISAM;
I'm beginning to think it's a MySQL problem also because this PHP SHOULD
work.
Tyler
- Original Message -
From: "John Steele" <[EMAIL PROTECTED]>
To: "PHP General List" <[EMAIL PROTECTED]>
Sent: Monday, November 12, 2001 3:33 PM
Subject: Re: [PHP] for loop problem?
> Hi Tyler,
>
> This doesn't sound like a problem with PHP, but MySQL. Can you show
your CREATE TABLE and MySQL version?
>
> John
>
> >Hi Martin,
> >
> >I just got done doing that, and i got the same thing! :-(
> >
> >Here's something interesting though. There's an id field that's set to
> >AUTO_INCREMENT. I did a "SELECT * FROM passcodes WHERE
passcode='P100'"
> >This gave me this:
> >
> >id | passcode
> >---
> >1 |P100
> >82145 |P100
> >209398 |P100
> >
> >Shouldn't the ID's be further apart than that? Know what I'm saying?
> >
> >Tyler
> >
> >- Original Message -----
> >From: "Martin Towell" <[EMAIL PROTECTED]>
> >To: "'Tyler Longren'" <[EMAIL PROTECTED]>; "Jack Dempsey"
> ><[EMAIL PROTECTED]>
> >Cc: "PHP-General" <[EMAIL PROTECTED]>
> >Sent: Monday, November 12, 2001 10:45 PM
> >Subject: RE: [PHP] for loop problem?
> >
> >
> >> How about changing the logic lightly? try this:
> >>
> >> $value1 = 0;
> >> $value2 = 223109;
> >> for($i=$value1; $i<=$value2; $i++) {
> >> $tmp = sprintf("1%06d\n", $i);
> >> mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$tmp')");
> >>
> >> basically taking away 1,000,000 from the numbers then adding it back on
> >> later
> >>
> >> Martin T
> >>
> >> -Original Message-
> >> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> >> Sent: Tuesday, November 13, 2001 3:38 PM
> >> To: Jack Dempsey
> >> Cc: PHP-General
> >> Subject: Re: [PHP] for loop problem?
> >>
> >>
> >> I've ran it a few times without the MySQL code in there. Runs just
fine
> >> that way for me too. After it's run a few times for me (with the MySQL
> >> code), I start getting duplicate entries of codes in there. For
example,
> >> I'll end up with a few 'P100' entries in the 'passcodes' field.
> >>
> >> Oh well, here I come perl!
> >>
> >> Thanks,
> >> Tyler
> >>
> >> - Original Message -
> >> From: "Jack Dempsey" <[EMAIL PROTECTED]>
> >> To: "Tyler Longren" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
> >> Sent: Monday, November 12, 2001 10:43 PM
> >> Subject: RE: [PHP] for loop problem?
> >>
> >>
> >> > ran it (without mysql queries) and worked finereal strange.
> >> > have you tried the loop without the mysql queries?
> >> >
> >> > -Original Message-
> >> > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> >> > Sent: Monday, November 12, 2001 11:28 PM
> >> > To: Jack Dempsey; [EMAIL PROTECTED]
> >> > Subject: Re: [PHP] for loop problem?
> >> >
> >> >
> >> > Exact code:
> >> > >> > $connection = mysql_connect("host_here","user_here","pass_here");
> >> > $db = mysql_select_db("db_here", $connection);
> >> > $value1 = 100;
> >> > $value2 = 1223109;
> >> > for($i=$value1; $i<=$value2; $i++) {
> >> > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> >> > if (mysql_error() != "") {
> >> > print "".mysql_error()."";
> >> > exit;
> >> > }
> >> > }
> >> > mysql_close($connection);
> >> > ?>
> >> >
> >> > Tyler
> >> >
> >> > - Original Message -
> >> > From: "Jack Dempsey" <[EMAIL PROTECTED]>
> >> > To: <[EMAIL PROTECTED]>
> >> > Sent: Monday, November 12, 2001 10:34 PM
> >> >
Re: [PHP] for loop problem?
I just ran your code as you pasted earlier, and set up a mysql database
with the table defined below ... and it inserted 223,110 passcodes into
the table.
PHP 4.0.99-3 (Identifies itself as 4.1.0RC1)
MySQL 3.23.43-3
~Chris /"\
\ / September 11, 2001
X We Are All New Yorkers
/ \ rm -rf /bin/laden
On Mon, 12 Nov 2001, Tyler Longren wrote:
> Hi John,
>
> MySQL Version: MySQL 3.23.44-nt
>
> SQL:
> CREATE TABLE passcodes (
> id int(11) NOT NULL auto_increment,
> passcode varchar(255) NOT NULL default '',
> PRIMARY KEY (id),
> KEY id (id,passcode)
> ) TYPE=MyISAM;
>
> I'm beginning to think it's a MySQL problem also because this PHP SHOULD
> work.
>
> Tyler
>
> - Original Message -
> From: "John Steele" <[EMAIL PROTECTED]>
> To: "PHP General List" <[EMAIL PROTECTED]>
> Sent: Monday, November 12, 2001 3:33 PM
> Subject: Re: [PHP] for loop problem?
>
>
> > Hi Tyler,
> >
> > This doesn't sound like a problem with PHP, but MySQL. Can you show
> your CREATE TABLE and MySQL version?
> >
> > John
> >
> > >Hi Martin,
> > >
> > >I just got done doing that, and i got the same thing! :-(
> > >
> > >Here's something interesting though. There's an id field that's set to
> > >AUTO_INCREMENT. I did a "SELECT * FROM passcodes WHERE
> passcode='P100'"
> > >This gave me this:
> > >
> > >id | passcode
> > >---
> > >1 |P100
> > >82145 |P100
> > >209398 |P100
> > >
> > >Shouldn't the ID's be further apart than that? Know what I'm saying?
> > >
> > >Tyler
> > >
> > >- Original Message -
> > >From: "Martin Towell" <[EMAIL PROTECTED]>
> > >To: "'Tyler Longren'" <[EMAIL PROTECTED]>; "Jack Dempsey"
> > ><[EMAIL PROTECTED]>
> > >Cc: "PHP-General" <[EMAIL PROTECTED]>
> > >Sent: Monday, November 12, 2001 10:45 PM
> > >Subject: RE: [PHP] for loop problem?
> > >
> > >
> > >> How about changing the logic lightly? try this:
> > >>
> > >> $value1 = 0;
> > >> $value2 = 223109;
> > >> for($i=$value1; $i<=$value2; $i++) {
> > >> $tmp = sprintf("1%06d\n", $i);
> > >> mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$tmp')");
> > >>
> > >> basically taking away 1,000,000 from the numbers then adding it back on
> > >> later
> > >>
> > >> Martin T
> > >>
> > >> -Original Message-
> > >> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > >> Sent: Tuesday, November 13, 2001 3:38 PM
> > >> To: Jack Dempsey
> > >> Cc: PHP-General
> > >> Subject: Re: [PHP] for loop problem?
> > >>
> > >>
> > >> I've ran it a few times without the MySQL code in there. Runs just
> fine
> > >> that way for me too. After it's run a few times for me (with the MySQL
> > >> code), I start getting duplicate entries of codes in there. For
> example,
> > >> I'll end up with a few 'P100' entries in the 'passcodes' field.
> > >>
> > >> Oh well, here I come perl!
> > >>
> > >> Thanks,
> > >> Tyler
> > >>
> > >> - Original Message -
> > >> From: "Jack Dempsey" <[EMAIL PROTECTED]>
> > >> To: "Tyler Longren" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> > >> Sent: Monday, November 12, 2001 10:43 PM
> > >> Subject: RE: [PHP] for loop problem?
> > >>
> > >>
> > >> > ran it (without mysql queries) and worked finereal strange.
> > >> > have you tried the loop without the mysql queries?
> > >> >
> > >> > -Original Message-
> > >> > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > >> > Sent: Monday, November 12, 2001 11:28 PM
> > >> > To: Jack Dempsey; [EMAIL PROTECTED]
> > >> > Subject: Re: [PHP] for loop problem?
> > >> >
> > >> &g
Re: [PHP] for loop problem?
Tyler,
It must be something weird with your NT version of MySQL, you might try asking on
the MySQL list, or checking the bug list on mysql.com. I have an even older version
here on 95, that doesn't display any of those problems.
Here's the code I used with it's output (no duplicates, I checked). Notice that I
did have to change the CREATE TABLE to meet 3.21.29a-gamma restrictions.
You might try changing the passcode to an int, and tacking the 'P' on the front in
your application. Not sure if that's possible...
John
';
if (!$qid = mysql_query("SELECT id,passcode FROM passcodes ORDER BY passcode DESC
LIMIT 10"))
die ("SELECT failed: ". mysql_error());
while ($arr = mysql_fetch_array($qid))
echo "$arr[0]: $arr[1]\n";
if (!mysql_close($connection))
die ("Can't close connection: ". mysql_error());
?>
And it's output:
INSERTs completed.
223110: P1223109
223109: P1223108
223108: P1223107
223107: P1223106
223106: P1223105
223105: P1223104
223104: P1223103
223103: P1223102
223102: P1223101
223101: P1223100
>Hi John,
>
>MySQL Version: MySQL 3.23.44-nt
>
>SQL:
>CREATE TABLE passcodes (
> id int(11) NOT NULL auto_increment,
> passcode varchar(255) NOT NULL default '',
> PRIMARY KEY (id),
> KEY id (id,passcode)
>) TYPE=MyISAM;
>
>I'm beginning to think it's a MySQL problem also because this PHP SHOULD
>work.
>
>Tyler
>
>----- Original Message -
>From: "John Steele" <[EMAIL PROTECTED]>
>To: "PHP General List" <[EMAIL PROTECTED]>
>Sent: Monday, November 12, 2001 3:33 PM
>Subject: Re: [PHP] for loop problem?
>
>
>> Hi Tyler,
>>
>> This doesn't sound like a problem with PHP, but MySQL. Can you show
>your CREATE TABLE and MySQL version?
>>
>> John
>>
>> >Hi Martin,
>> >
>> >I just got done doing that, and i got the same thing! :-(
>> >
>> >Here's something interesting though. There's an id field that's set to
>> >AUTO_INCREMENT. I did a "SELECT * FROM passcodes WHERE
>passcode='P100'"
>> >This gave me this:
>> >
>> >id | passcode
>> >---
>> >1 |P100
>> >82145 | P1000000
>> >209398 |P100
>> >
>> >Shouldn't the ID's be further apart than that? Know what I'm saying?
>> >
>> >Tyler
>> >
>> >- Original Message -
>> >From: "Martin Towell" <[EMAIL PROTECTED]>
>> >To: "'Tyler Longren'" <[EMAIL PROTECTED]>; "Jack Dempsey"
>> ><[EMAIL PROTECTED]>
>> >Cc: "PHP-General" <[EMAIL PROTECTED]>
>> >Sent: Monday, November 12, 2001 10:45 PM
>> >Subject: RE: [PHP] for loop problem?
>> >
>> >
>> >> How about changing the logic lightly? try this:
>> >>
>> >> $value1 = 0;
>> >> $value2 = 223109;
>> >> for($i=$value1; $i<=$value2; $i++) {
>> >> $tmp = sprintf("1%06d\n", $i);
>> >> mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$tmp')");
>> >>
>> >> basically taking away 1,000,000 from the numbers then adding it back on
>> >> later
>> >>
>> >> Martin T
>> >>
>> >> -----Original Message-
>> >> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
>> >> Sent: Tuesday, November 13, 2001 3:38 PM
>> >> To: Jack Dempsey
>> >> Cc: PHP-General
>> >> Subject: Re: [PHP] for loop problem?
>> >>
>> >>
>> >> I've ran it a few times without the MySQL code in there. Runs just
>fine
>> >> that way for me too. After it's run a few times for me (with the MySQL
>> >> code), I start getting duplicate entries of codes in there. For
>example,
>> >> I'll end up with a few 'P100' entries in the 'passcodes' field.
>> >>
>> >> Oh well, here I come perl!
>> >>
>> >> Thanks,
>> >> Tyler
>> >>
>> >> - Original Message -
>> >> From: "Jack Dempsey" <[EMAIL PROTECTED]>
>> >> To: "Tyler Longren" <[EMAIL PROTECTED]>;
><[EMAIL PROTECTED]>
>> >> Sent: Monday, November 12, 2001 10:43 PM
>> >> Subject: RE: [PHP] for loop problem?
>> >>
>> >>
>> >>
Re: [PHP] for loop problem?
Tyler Longren wrote: > > Here's something interesting though. There's an id field that's set to > AUTO_INCREMENT. Yep, and that's one thing I've been looking at. See, I find it strange that you need an KEY idpass (id, passcode(245)) when the ID is quaranteed to be unique in itself. Funny... Would not explain why you get more, I'd rather expect you to get fewer entries. Anyway. Try this: Drop the passcode VARCHAR and make it fixed CHAR(10). It seems like MySQL can't keep up with the speed of your inserts, and varchar is obnoxiously slow. -- PHP General 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]
