I think I have something that will do the trick thanks to everyones help.

$name_1_aaa = "Jimmy";
$name_2_aaa = "Janis";
$name_3_aaa = "Joe";

for ($i = 1; $i <= 3; $i++)  {
$arr_name[$i] = 'name_'.$i.'_aaa';
}

echo ${$arr_name[1]}.'<br>';
echo ${$arr_name[2]}.'<br>';
echo ${$arr_name[3]}.'<br>';

Displays:

Jimmy
Janis
Joe

Now I can do something like this for all my updates....

for ($i = 1; $i <= 3; $i++)  {
    $query_update = "UPDATE table SET name='${$arr_name[$i]}' WHERE
name_id='$i'";
     $result_update = mysql_query($query_update) or die("Query failed");
}


Thanks for all the help!

Jeff


----- Original Message -----
From: "Jason k Larson" <[EMAIL PROTECTED]>
To: "Jeff Pauls" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, February 25, 2003 3:37 PM
Subject: Re: [PHP] Auto Incrementing a Variable name?


> $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
>
>
>



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

Reply via email to