RE: [PHP] for loop problem?

try removing the quotes and see if that works eg $value1 = "1000000"; becomes $value1 = 1000000; and for($i="$value1"; $i<="$value2"; $i++) { becomes for($i=$value1; $i<=$value2; $i++) { Martin T -----Original Message----- From: Tyler Longren [mailto:tyler@captainjack.com] 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 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