Change Array Names

[stonefish]

I have the following loop in my code.

while($row = mysql_fetch_array($rs)) {
$x=1;
for($i = 1; $i <= 100; $i++){
$results[$i] = $row[$x];
$x++;
}
}

This loops fills the array $results with the columns 1 to 100 from a particular row in a table.

This loops again for the number of results the mysql_fetch_array($rs) returns.

I was wondering if I could change the name of $results everytime the mysql_fetch_array($rs) looped. This would mean having a different named array for each row returned from the mysql_fetch_array($rs) loop.

Thanks

[barand]

Why don't you just make results an array of rows?

while($row = mysql_fetch_row($rs)) {

       $results[] = array_slice($row, 1, 100);

}

[Installer]

If, for instance, you wanted to name the arrays "$result1", "$result2", etc:

while ($row = mysql_fetch_array($rs)) {
    $x = 1;
    for ($i = 1; $i <= 100; $i++){
        ${'results' . $i} = $row[$x];
        $x++;
    }
}

(The most common uses for this technique are to avoid learning to use arrays and to confuse the coder and anyone else who has to maintain the code.)