Loop

Senior WebHelper Joined: 21 Apr 2003 Posts: 153

How would I loop some code to go 30 times?

Team Member Joined: 06 Jan 2002 Posts: 2564

What code? I don't understand how this is database related... Confused

Do you mean in PHP?

Senior WebHelper Joined: 21 Apr 2003 Posts: 153

Oh yeah sry, PHP loop, I want to run some code 30 times and then stop.

Team Member Joined: 06 Jan 2002 Posts: 2564

Code:

$i = 1;
while ($i < 30) {
code_to_run();
$i++;
}

Senior WebHelper Joined: 21 Apr 2003 Posts: 153

How would I put this code into the loop

Code:

$sql = "INSERT INTO Gruhn_Stats (ab) VALUES (NULL)";
$result = mysql_query($sql)
or die("Invalid query: " . mysql_error());

$result = mysql_query("SELECT * FROM Robinson_Stats")
or die("Invalid query: " . mysql_error());

Team Member Joined: 06 Jan 2002 Posts: 2564

Code:

$i = 1;
while ($i < 30) {
$sql = "INSERT INTO Gruhn_Stats (ab) VALUES (NULL)";
$result = mysql_query($sql)
or die("Invalid query: " . mysql_error());

$result = mysql_query("SELECT * FROM Robinson_Stats")
or die("Invalid query: " . mysql_error());
$i++;
}

I guess

Posted: Mon Apr 28, 2003 7:07 pm (20 years, 11 months ago)

Code:

for ($i = 1; $i < 30, ++$i) {
$sql = "INSERT INTO Gruhn_Stats (ab) VALUES (NULL)";
$result = mysql_query($sql)
or die("Invalid query: " . mysql_error());

$result = mysql_query("SELECT * FROM Robinson_Stats")
or die("Invalid query: " . mysql_error());
}

would be better than a while loop...though I can't see what use the code is either way.