Sequentialy numbered variables

[Anon]

I have a string coming out of my database that contains the names of different bands. The bands are all seperated by the period '.'

$bands = $row["bands"];
list(
for($y = 0 ; $y< count($bands); $y++){

		 		print ${"bands$y"}; 

		 	}
		 	) = explode(".",$bands);
		 	for($x = 0; $x < count($bands); $x++){
		 		print ${"bands$x"};
		 	}

With this I am trying to define a list for exploding the variables into, then print all the variables. This code does not work could anyone tell me why not? and suggest a solution... thanks 🙂

[Anon]

How about this:

$bands = $row["bands"];
band_array= explode(".",$bands);
for($x = 0; $x < count($band_array); $x++){
${"bands".$x}=$band_array[$x];
}

I don't know why you would want to do that though, you can refer to the values like:

$band_array[0]

easier than

$bands0

at least that's what I think.

[greg252]

Sounds like a case for normalization!
Why not create another table to hold the individual band names with another column that refers to the group that they belong to (external key). This would eliminate the whole explode thing.

I think.