I am having trouble figuing out how to do this...

Namadoor

So it has 2 columns, a var name column, and one to store the contents of that var. Now, I want to creat a function that will get all the var names and var contents, but then it will store the var contents in the var name. (I am using PHP by the way)

So far I have got something like this:

function GetVars()	{
	$query = "SELECT * FROM mbvars";
	$result = mysql_query($query)	or die("Could not execute query");
	while($mr = mysql_fetch_array($result))	{
		echo "$mr[varname]";
		$mr[varname] = $mr[varcont];
		echo "$mr[varname]";
	}
}

But what is happing is that the var contents are overwriting the var name, where I want it stored to the var name...

Is there anyway of doing this, or is it impossible?

Shriekback

stored too? like together?

$mr[varname] .= $mr[varcont];

this will combine the 2 strings.
if you wanted to use the varname as an identifier to varcont, then it would go something like
$mr[varname][] = $mr[varcont];
this would be a multi dimensional array.

Hmm.. kinda vague on this.

Namadoor

What I want is somehow to delcare $mr[varname] as a varible (With the value being the varible name) and put the value of $mr[varcont] into that varible.

TTT

make it like this

$totalIndexOfRows = 0;
while
{
$array[$totalIndexOfRows][0] = mysql_result($query,1) //name
$array[$totalIndexOfRows][1] = mysql_result($query,2) //content
$totalIndexOfRows++
}