creating variables automatically in a loop

[SteveYantz]

I'm not sure, but I thought there was a way to rename variables and/or change them to create additional variables.

Can someone enlighten me?
lets say I grab a query that says the maximum of the season field is 6.
I run a loop loops through 6 times, running 6 seperate queries.
These queries grab all the rows that have season fields that are the same number as the loop's number.

I need variable for each query.
But I can't create these variables manually, because I don't know how many queries will run.

[jaligamasr]

You can create an array variable and put in the loop and you can later refer it.

[SteveYantz]

hmmm... can I ask what that might look like. I'm still a bit amature with php. Just started teaching it to myself about a month ago.

[jaligamasr]

you can create an array variable like this
$xyz = array();

lets assume a loop
while(condition)
{
$xyz[ ] = /* store the retrieved value */

}

in order to retrieve the value
use foreach( $xyz as $value) syntax
or u can refer normally as $xyz[i] also if you want to know the length of the array use the function count($xyz)
I hope this work or else please provide you syntax so that I can figure out some possible solution

[SteveYantz]

So something like this?
I've presented the query I'd be using.
Yes it's got shortcut functions that wordpress created.

$seasonCount = '6';
$sArray = array();


for ($i = 1; $i <= $seasonCount; $i++)
{
$sArray[ ] = $wpdb->get_result("
	SELECT post_episode
	  FROM $wpdb->posts key1
	INNER JOIN $wpdb->term_relationships key2
            	  on key1.ID = key2.object_id
	WHERE key2.term_taxonomy_id = $categoryID
	  AND key1.post_status = 'publish'
	  AND key1.post_type = 'post'
	  AND key1.post_season = $i
	ORDER BY post_episode ASC");

}

If this is the syntax, how would I call it into a looping set of divs?
Something like this?

<?php for ($i = 1; $i <= $seasonCount; $i++){ ?>

<div> 

<?php 
foreach ($sArray[$i] as $sArray[$i]) {
 echo $sArray[$i];
} ?> 

</div>

<?php } ?>

[jaligamasr]

use this way

<?php 
foreach ($sArray as $value) 

 echo '<div>'.$value. '</div>';
 ?>

[SteveYantz]

Alright thanks, and the $value would be the number of each row on the array?

[jaligamasr]

$value holds the value retrieved from each iteration

you can also refer the array this way

for($i =0 ; $i < count($sArray); $i++)

echo $sArray[$i];

[SteveYantz]

well seeing that each querie is also something like an array.
It's not just one result the querie is returning. It's collection of rows.
Since normally you refer to it's rows in a foreach loop

"foreach ($variable as $variable)"

and you call a field

"$variable->fieldname"


this is why I had both a for, and a foreach.
One to loop through the first array (which used the seasonCount that is par to the array count,) the foreach was my attempt to loop through the inner array (loop through the query.)



can an array be inside an array?

[jaligamasr]

Yes can put array in an array. Hope this will solve your problem
<?php
foreach ($sArray as $value)
foreach ($value as $value1)
echo '<div>'.$value1. '</div>';
?>