[SOLVED] assigning variables to data from loop

[DamienRoche]

Here's the issue.

 

I have a simple loop which drags all rows of data from a mysql table. What I am trying to do is assign a variable to each column within each row, relative to the amount of times the while has looped.

 

Here is where I am stuck, namely, assigning variables to the first column "fname".

 

$loop3="1";
while($row = mysql_fetch_array($data, MYSQL_ASSOC)) { 

$varFNAME = "\$fname"."$loop3";

$fnametest = $row['Employee_F_Name'];

$assignFNAME = "$varFNAME"." = "."\"$fnametest\";";

echo "$assignFNAME<br>";

$loop3 = $loop3 + 1;
?>

 

The output for that is the php code I need to function as php:

 

$fname1 = "1fname";

$fname2 = "2fname";

$fname3 = "3fname";

$fname4 = "4fname";

$fname5 = "5fname";

$fname6 = "6fname";

 

But how can I do that?

 

Any help is greatly appreciated.

 

Thanks.

[ratcateme]

i have never used this method before but try this

replace

$assignFNAME = "$varFNAME"." = "."\"$fnametest\";";

with

$$varFNAME = $fnametest;

have you considered using an array though? like this kinda thing

$fname=array();
while($row = mysql_fetch_array($data, MYSQL_ASSOC)) { 
$fname[] = $row['Employee_F_Name'];
}
print_r($fname);

should print

array(
0 => 1fname
1 => 2fname
...
)

 

Scott.

[DamienRoche]

Thanks! That sorted it. Do you know how I can start the array from 1 instead of 0.

 

Right now it's [0] => 1fname [1] => 2fname etc.

 

Thanks again.

[JasonLewis]

$fname=array();
$i = 1;
while($row = mysql_fetch_array($data, MYSQL_ASSOC)) { 
$fname[$i] = $row['Employee_F_Name'];
$i++;
}
print_r($fname);

 

It's better to start it at 0 though, it's how arrays work.

[DamienRoche]

I think I'll keep it how it is then. Thanks for the pointer.