A Variable Variable

[likelylad]

This post is a follow on from the following thread:

http://www.tek-tips.com/viewthread.cfm?qid=1463532&page=1

As it stands my code looks like this and it does exactly what I want it to do

// MySQL Connection String
$column=$_GET[thedesc];
parse_str($_POST['data']);
 
for ($i = 0; $i < count($callcentreColumn1); $i++) {   
    // The following line is for the MySQL query.   
mysqli_query($db,"INSERT INTO tablename (Tabname,ColumnNumber) VALUES('$column','$callcentreColumn1[$i]')");   
}

The problem I have, is where the words callcentreColumn1 exists. This can/will be different nearly every time, so my question is how to correctly use the correct variable.

The variable name is been received using:

$column=$_GET[thedesc];

Therefore the $column maybe equal to callcentreColumn1 or accountsColumn1 or lionsColumn1 etc


I hope I am being clear.

 

[likelylad]

Ended up figuring it out myself

This is the code that I am working off now:

// MySQL Connection String
$column=$_GET[thedesc];
parse_str($_POST['data']);
 
for ($i = 0; $i < count(${$column}); $i++) { 
$data=${$column}[$i];  
    // The following line is for the MySQL query.   
mysqli_query($db,"INSERT INTO tablename (Tabname,ColumnNumber) VALUES('$column','$data')");   
}