I'm a bit dense when it comes to arrays so I need a little help trying to understand what's going on with this code and how to fix it. Here's the code;

PHP Code:

for ( $n = 0; $n < 4; $n++) {

    $blogRSS=mysql_result($result,$n,"blogRSS");
    
        $urls=array($blogRSS);
} 


I'm trying to loop through some results and add the $blogRSS variable (which is a RSS feed link) to this array. There are only four (4) results but it only gets the last one.

What do I need to do to this code to make it add each feed link into the array?

It should be like below

PHP Code:

for ( $n = 0; $n < 4; $n++) {

    $blogRSS=mysql_result($result,$n,"blogRSS");
    
        $urls[]=array($blogRSS);
} 


Now $urls array will get 4 results in elements $url[0],$url[1].. etc

The main problem you have is that the results keep overwriting the previous one at each interval.

$urls = Array();
 
for ($n = 0; $n < 4; $n++) {
 
$blogRSS = mysql_result($result, $n, "blogRSS");
 
$urls[] = $blogRSS;
 
}

The above sets up your $urls var as an array.

$urls = Array();
 
for ($n = 0; $n < 4; $n++) {
 
$blogRSS = mysql_result($result, $n, "blogRSS");
 
$urls[] = $blogRSS;
 
}

This will start a loop of four intervals (iterations)

$urls = Array();
 
for ($n = 0; $n < 4; $n++) {
 
$blogRSS = mysql_result($result, $n, "blogRSS");
 
$urls[] = $blogRSS;
 
}

This will caputure the results from row N from column blogRSS and assign the value to var $blogRSS. The array $urls will add a new element with that value.

So, the final code is...

PHP Code:

$urls = Array();
for ($n = 0; $n < 4; $n++) {
 
  $blogRSS = mysql_result($result, $n, "blogRSS");
 
  $urls[] = $blogRSS;
 
}