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 = 1000000;
> > $value2 = 1223109;
> > for($i=$value1; $i<=$value2; $i++) {
> > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > if (mysql_error() != "") {
> > print "<font face=Arial size=2>".mysql_error()."</font>";
> > 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 1000000 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 = "1000000";
> > > $value2 = "1223109";
> > > for($i="$value1"; $i<="$value2"; $i++) {
> > > mysql_query("INSERT INTO passcodes (passcode) VALUES ('P$i')");
> > > if (mysql_error() != "") {
> > > print "<font face=Arial size=2>".mysql_error()."</font>";
> > > 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]
