complicated string/array/variable issue

[Pyro4816]

For this example, $row2['author'] = "1"

$user = 'user'.$row2['author'];
if (!isset($$user)){
      $result = $connector->query('SELECT * FROM users WHERE ID = '.$row2['author']);
      $$user = $connector->fetchArray($result);
}
echo '<a href="user.php?user='.($$user['ID']).'">'.$$user.'</a></p>';

The problem is it is a weird variable that also has an array, but when i use

echo $$user['ID'];

It errors out saying Notice:

Undefined variable: u

 

So I am wondering how to word it to set the variable up properly, and how to call items in the array. Thanks in advance

[Pyro4816]

It wouldn't let me edit again, but an update on it is that

echo $user1['ID'];

Works, but since this is in a while loop, and i am trying to prevent too many server queries, im trying to set it so that if i need user 1's info again it wont query the database again, but it will query it if there is a user 2 who has not had his info retrieved.

[joel24]

are you intending to use a variable variable...?

if (!isset($$user)){

 

echo $$user['ID'];

 

you're using the $$user variable variable 4 times in that script.

 

unless you have a need for a variable variable, just use $user

[Pyro4816]

i am trying to use a variable variable, the problem lies in using the array from a variable variable.

[joel24]

I would use an array from the start

i.e.

$user = 'user'.$row2['author'];
$userArray = array();
if (!isset($$user)){
      $result = $connector->query('SELECT * FROM users WHERE ID = '.$row2['author']);
      $userArray[$user] = $connector->fetchArray($result);
}
echo '<a href="user.php?user='.$userArray[$user]['ID'].'">'.$user.'</a></p>';

 

play around with that, otherwise do print_r($$user); to ensure the variable variable array is setup as you wish.