[RESOLVED] Loops and Variables

[cshepherd]

Hi,

I'm developing a small application that needs to repeated call on a series of recordsets that are similarly named. What I would like to do is call these recordsets in turn, display the contents. Repeat for each of the of them.

Assuming I have recordsets name rset0, rset1 ... rset9. The recordsets themselves have been declared earlier. The following code doesn't work obviously but i hope shows what I am trying to achieve.

<?php for ($i = 0; $i <= 9; $i++) {
mysql_data_seek($rset.$i, 0);
while ($row_rset.$i = mysql_fetch_assoc($rset.$i)) {
echo "rset".$i." - data - ".$row_rset.$i['fruit'];
}
?>

I would hope that this would return:

rset0 - data - apple
rset0 - data - pear
rset0 - data - lemon
rset1 - data - orange
rset1 - data - melon
.
.
.
rset9 - data - plum
rset9 - data - peach

Can anyone help me with the syntax of concatenating the variables so that it PHP reads $rset.$i as $rset0, $rset1, etc on each iteration. I'm not entirely sure that this is possible to achieve, i just hope there is.

Many thanks for your time.

C Shepherd

[suomynonA]

Here's a code that you can adapt to your needs, I wrote it this way so you can see in some detail what's the idea:

<?php

$var1="Hello";
$var2="W";
$var3="o";
$var4="r";
$var5="l";
$var6="d";

for ($i=1;$i<=6;$i++)
{
$temp='var'.$i;
echo($$temp);
}

?>

[cshepherd]

Spot on!

Worked first time once I tweaked my code.

Thanks very much for supplying that solution - you have saved me an awful lot of work

Cheers!

[ahundiak]

$rset_name = $rset.$i;
mysql_data_seek($$rest_name, 0); 

The double $ is the key. However, doing things like this is seldom necessary and is usually confusing. Why not store your result sets in an array and then use a foreach to loop through?

[cshepherd]

I appreciate the comment (and the solution obviously).

For reasons that are a bit complicated to explain I've had to construct the recordsets individually. I felt it made more sense to simple requery (data_seek) them and display the data rather than adding in additional array handling. I

Its a pretty discrete chunk of code so while the confusion is a risk i'll chance it in this case.

It is a good point though.

[suomynonA]

Glad to be of help. If you consider there's nothing else to ask on this matter, please mark this threads as Resolved (under "Thread Tools").

[cshepherd]

Will do. Thanks again