Inserting values with variables and loop

Anon

Hello,

I'm inserting data into a mysql database using a loop.

So far i have made this code but it isn't working.

$i = 1;
while ($i <= $Attendance)
{
$result = mysql_query("INSERT INTO nbalive_daybyday (DateID, GP, Nickname, PTS, PPG, FGM, FGA, FGP, 3PM, 3PA, 3PP, FTM, FTA, FTP, REB, RPG, BLK, BPG, STL, SPG, AST, APG, FL, FPG, PF, PFG, PA, PAG, OR, ORG, DR, DRG, TO, TPG) VALUES ('$DateID', '$GP' . $i. , '$Nickname' . $i. , '$PTS' . $i. , '$PPG' . $i. , '$FGM' . $i. , '$FGA' . $i. , '$FGP' . $i. , '$3PM' . $i. , '$3PA' . $i. , '$3PP' . $i. , '$FTM' . $i. , '$FTA' . $i. , '$FTP' . $i. , '$REB' . $i. , '$RPG' . $i. , '$BLK' . $i. , '$BPG' . $i. , '$STL' . $i. , '$SPG' . $i. , '$AST' . $i. , '$APG' . $i. , '$FL' . $i. , '$FPG' . $i. , '$PF' . $i. , '$PFG' . $i. , '$PA' . $i. , '$PAG' . $i. , '$OR' . $i. , '$ORG' . $i. , '$DR' . $i. , '$DRG' . $i. , '$TO' . $i. , '$TPG' . $i. )");
}

I think the "concentation" is not good but i don't know how to do it. I need to get the values PTS1, GP1, PPG1, and then PTS2, GP2, PPG2 etc...
Mine is ....VALUES ('$data' .$i. etc etc). I hope this is clear.

stuartc1

try it again but without any . (dots) - like this : '$GP$i' you dont need the dots.

Anon

Thanx a lot, wil go try it out.

Anon

It's not really working, i get the 30 second execution timeout 🙁

stuartc1

can you post more of your code so we can see how its hanging together ?

Anon

Here is the complete code

<?php
mysql_connect (localhost, you really think ?);
mysql_select_db (luckyyou);

$i = 1;
while ($i <= $Attendance)
{
$result = mysql_query("INSERT INTO nbalive_daybyday (GP, Nickname, PTS, FGM, FGA) VALUES ('$GP$i' , '$Nickname$i' , '$PTS$i', '$FGM$i' , '$FGA$i')");
}
echo "Previous data has been entered <br>";
?>

stuartc1

maybe you should increment you $i variable so it will no when to stop !!

try this :
while ($i; <= $Attendance; $i++) {
// your code
}

or add a $i++ before the end of each loop.

Anon

Ok, here's the complete code.

$i = 1 ;
while ($i <= 3) {

print $i; //just to check

    $result  = mysql_query("INSERT INTO nbalive_daybyday (GP, Nickname, PTS, FGM, FGA) VALUES ('$GP$i' , '$Nickname$i' , '$PTS$i', '$FGM$i' , '$FGA$i')");

$i++;
}

The $i gets printed correctly but somehow it just fills my database with "1"'s, that's something like 29366 rows !! That's really weird.