Dynamically Naming Variables

[squiggerz]

Ok, I'm pulling values from a db, the values are all domain names.

 

Is there any way after pulling them in with a while loop, that I can define a variable name as the value of what I have pulled?

$query = "SELECT city FROM cities ORDER BY city";
$results = mysql_query($query);
while ($row = mysql_fetch_array ($results, MYSQL_ASSOC)) 
{
           $thisiswhereIwantTheValueToGo = $row['city'];
} 			

 

I understand that the above will make the value of the variable = to the $row['city'], is there any way I can dynamically create the variable name based on that same value?

[vijayfreaks]

hi

you can do this with the following:

 

    while (list($city) = mysql_fetch_row($result))       

    {

            // $city is ur same name var where we've different value row wise

    }

Regards,

Vijay

[GingerRobot]

Variable variables?:

 

<?php
$query = "SELECT city FROM cities ORDER BY city";
$results = mysql_query($query);
while ($row = mysql_fetch_array ($results, MYSQL_ASSOC)) 
{
           $$row['city'] = $row['city'];
}
?>