[RESOLVED] creating a variable from database

[shuka79]

Hi Folks,

I have a while loop that fetchs a name from the DB, I am then trying to use the name as a php variable.

I have several variable setup

$business
$title
$body

while($row = mysql_fetch_array($res)) {
      echo $row['html'];
      $primary = $row['structure'];
      // $primary will fetch business, title, body etc
      echo $ID = $.''.$primary;
      echo $row['html2'];
} ?>

If anyone can see what am doing wrong that would be great

Cheers
Shuka

[NogDog]

This line does not parse:

      echo $ID = $.''.$primary;

As I'm not exactly sure what you want there, I'm not sure what the "fix" is

[johanafm]

It looks like a strange setup. Why store a variable name instead of the actual value? You should probably rethink your design, and store $business, $title and $body in the db instead.

$$primary

[bradgrafelman]

As johanafm suggests, there's probably a better DB design/schema that accommodates what you're trying to do.

What you're trying to do now (at least as far as I can tell), however, is called using "variable variables." The manual page for this topic can be found here: [man]variables.variable[/man]. Here's a brief coding example:

<?php

$foobar = 'Hello world!';

$var = 'foobar';
echo $$var; // Hello world!

$prefix = 'foo';
$suffix = 'bar';
echo ${$prefix . $suffix}; // Hello world!

[shuka79]

Thanks all for your suggestions, I have resolved this issue by using

echo $ID = ${$primary};