Generate variablenames

ThoTruck

How do I automaticaly generate variablenames?

My best bet so far is:

$i = 1;
$sql.$i = "SELECT and all that...";
$getit.$i = mysql_db_query ($DBnavn, $sql.$i, $Connect) or die(mysql_error());
$array.$i = mysql_fetch_array($getit.$i);
$totalRows.$i = mysql_num_rows($getit.$i);

It works fine with "$sql.$i" and "$getit.$i" but the "fetch_array()" and "num_rows()" chokes on it

What I need is somehow to generate the varnames automaticaly so the system doesn't mess things up when I include() it "on top of it self" - if you know what I mean?
It's used in building a hieraki...

Thanx in advance
Thomas

Drakla

Maybe you should look at variable variables

I'm not sure what you're trying to do, but variable variable names probably isn't the way of going about it, maybe arrays would do you better.

ThoTruck

It supposed to work via multible include() of the same script...
Lets see if I can explain it.
do {
$i = 1;

$sql.$i = "SELECT and all that...";
$getit.$i = mysql_db_query ($DBnavn, $sql.$i, $Connect) or die(mysql_error());
$array.$i = mysql_fetch_array($getit.$i);
$totalRows.$i = mysql_num_rows($getit.$i);

if ($anothervalue == $array.$i[]) {

$i++;

if true = including it again

$sql.$i = "SELECT and all that...";
$getit.$i = mysql_db_query ($DBnavn, $sql.$i, $Connect) or die(mysql_error());
$array.$i = mysql_fetch_array($getit.$i);
$totalRows.$i = mysql_num_rows($getit.$i);

if ($anothervalue == $array.$i[]) {
$i++;
if true = including it again
etc...

}

}
} while (another array is OK);

There is probably errors in it here, so don't worry 'bout that - its the $varname.$i thats the big bully here...
It is supposed to be able to include itself "eternaly" to build a potentialy neverending hieraky, and to do so, I need it to come up with new variablenames to prevent the "if" and "while" to clash

ThoTruck

I found this:
http://www.phpbuilder.com/columns/robert20000928.php3
Maybe it will help.

Testing testing... 🆒

ThoTruck

$i++;
$sql.$i = "SELECT and all that...";
$getit.$i = mysql_db_query ($DBnavn, $sql.$i, $Connect) or die(mysql_error());
$array.$i = mysql_fetch_array($getit.$i);
$totalRows.$i = mysql_num_rows($getit.$i);

is supposed to be:

$i++;
${$sql.$i} = "SELECT and all that...";
${$getit.$i} = mysql_db_query ($DBnavn, ${$sql.$i}, $Connect) or die(mysql_error());
${$array.$i} = mysql_fetch_array(${$getit.$i});
// ${$totalRows.$i} = mysql_num_rows(${$getit.$i});

"mysql_num_rows()" doesen't agree with this method, so keep that in mind...
The same with "mysql_fetch_assoc()" - apparently has to be "mysql_fetch_array()"