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:tyler@captainjack.com] Sent: Tuesday, November 13, 2001 2:53 PM To: Evan Nemerson; php-general@lists.php.net 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" <evan@coeus-group.com> To: "Tyler Longren" <tyler@captainjack.com>; <php-general@lists.php.net> 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net