declare variable from sql query

[sogorman]

I am trying to take a table with two columns [key] and [value] and use a while loop to set a variable using the key as the variable name and value as the value but I am having a hard time figuring out how to make it work in a while loop...

 

I know this will not work....

$result = mysql_query("SELECT * from global");
while($r = mysql_fetch_assoc($result)) {
	$r['key'] = $r['value'];
}

[requinix]

I am trying to take a table with two columns [key] and [value] and use a while loop to set a variable using the key as the variable name and value as the value

Don't. Stick with the array you have. Making variables like that is bad practice and doesn't really afford you anything you can't get done through better means.

[AbraCadaver]

I can't totally agree with requinix because I don't know what use you have for this array and the values.  There may be an application for this but we don't have enough info.  If you want an associative array of key/value then maybe like this:

while($r = mysql_fetch_assoc($result)) {
	$array[$r['key']] = $r['value'];
}

[requinix]

Hadn't considered the purpose. Yeah, an associative array like that would be much better than trying to stay with just the $r variable >_>