Concatenating code in mysql_query

Anon

I'm trying to concatenate (spelling) this string in a mysql query.
First this code:

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

With this code i get
GP1, Nickname1, PTS1 etc
GP2, Nickname2, PTS2 etc

What i need is to get the VALUES of these data so i need.

$GP1, $Nickname1, $PTS1 etc
$GP2, $Nickname2, $PTS2 etc

I tried this code but it didn't work...

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

When i try this code:
$result = mysql_query
("INSERT INTO nbalive_daybyday
(GP, Nickname, PTS, FGM, FGA)
VALUES ('$GP".$i."' , '$Nickname".$i."' , '$PTS".$i."', '$FGM".$i."' , '$FGA".$i."')");
i get this in the database:
1, 1, 1, etc
2, 2, 2, etc

These are NOT the values....

Anybody know how to do this ?

Anon

I think you'll need to define the variables before you make the query.

$gp = $gp.$i;
$nick = $nickname.$i; etc etc

Then:

... VALUES ('". $gp ."', '". $nick ."', '....

You'll need to do a "for" loop so that it loops through the INSERT the rigt amount of times for however many variables there are..

for ($i=0;$i < $numberOfRows;$i++) {

Hope this helps.

Anon

YES YES YES.

I think this may be it, i'll go work on this right now.

Thank you very very very very very very very very very very very very very very very very very very very very very very very very very very much !!!!

Anon

Not yet,

i can't assing the variables.

$GP = $GP.$i is not working
$GP = $GP$i is not working neither.

the code is now...

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

$GP = $GP$i ;
$Nickname = $Nickname$i ;
$PTS = $PTS$i ;
$FGM = $FGM$i ;
$FGA = $FGA$i ;

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

}