Re: [PHP] Auto Incrementing a Variable name?

[Jason k Larson]

$name1 = 'Hello, World!';
$i = 1;
$var = 'name'.$i;
print ${$var};
HTH,
Jason k Larson
Jeff Pauls wrote:
Hi,
I've been playing with this for a while now. Say I had the following variables:
$name1 = "joe";
$name2 = "janis";
$name3 = "joanne";
Is there a way in php to increment the variable name not the value? Something like this....

for ($i = 1; $i <= 3; $i++)  { 
 $arr_name[$i] = $name.$i;         // I want $name1,$name2,$name3 etc.... 
}

This way say if I had 500 database queries that need to be updated I could just loop through each and just change the record id.....

for ($i = 1; $i <= 500; $i++)  { 

$query_update = "UPDATE table SET name=' $arr_name[$i]',  WHERE person_id='$i";
$result_update = mysql_query($query_update) or die("Query failed");
}
instead of doing something like this:

$query_update1 = "UPDATE table SET name=' $name1',  WHERE person_id='1";
$result_update1 = mysql_query($query_update1) or die("Query failed");
$query_update2 = "UPDATE table SET name=' $name2',  WHERE person_id='2";
$result_update2 = mysql_query($query_update2) or die("Query failed");
$query_update3 = "UPDATE table SET name=' $name3',  WHERE person_id='3";
$result_update3 = mysql_query($query_update3) or die("Query failed");
etc.....

Anybody? There has to be a way of doing this...

Thanks,

Jeff


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php