在mysql字段中使用php变量

I have a field in a Mysql table which contains php variable, which is used to determine the directory where a file is stored (ex. Docs/$CompID/ and Acc/$AccID/). The problem is that when I retrieve the value, the php variable name is display instead of the value.

I tried placing quotes around the value -

Both in the Mysql table (Docs/$CompID/" and Docs/".$CompID."/)

and when the php variable is displayed (echo"$dir")

I also tried doing str_replace, putting { } around the variable so that I can identify it in the string:

$start=strrpos($cat['dir'],'{');
$stop=strrpos($cat['dir'],'}');
$rep=substr($cat['dir'],$start+1,$stop-1);
$dir=str_replace("{".$rep."}",$rep,$cat['dir']);

All of these just displayed the php variable name. Any help would be appreciated!

You can use eval()

$AccID = 'me';
eval("\$str = \"Acc/$AccID/\";");
echo $str;

If I am correct you variable would look like this: var. You can access $var with $$cat["dir"]. However, if you db variable looks like $var, just use a simple substring to remove the $.