[RESOLVED] Array problem

[7724]

Hi,

Having some trouble with an array. Say my array is like so

while($record = mysql_fetch_assoc($result))
{

// Create an array holding the positions and an $n+ to grab the Values 
$test[] = "red";
$test[] = "green";
$test[] = "blue";
$test[] = "black";
$test[] = "white";

$n=0;

$query_two = "UPDATE table SET test= $test[''.$n.'']"; 
mysql_query($query_two)  OR die(mysql_error()); 
$number_of_results = mysql_num_rows($result);

$n++; }

But How can I say to my query go back to the first $test[] again after the value white has been inserted (so it starts again).

Thanks

[rincewind456]

You could put an IF in there to test is $n ==4 and reset it to 0, BUT that would create an infinite loop, which you should probably avoid. So if you wanted to run through a set no of times you would need another loop to regulate how many.

[7724]

Thanks tried that like this:

if ($n == 4) {
$n=0;
} else {
$n=0;
}

Now am I being really dim, or when $n == 4 the counter should reset?

[Installer]

If I read your question correctly, I think something like this will get it done:

$test[] = "red";
$test[] = "green";
$test[] = "blue";
$test[] = "black";
$test[] = "white";
$num_loops = 2;
for ($loop = 0; $loop <= $num_loops; $loop++)
    while ($record = mysql_fetch_assoc($result)) {
        foreach ($test as $color) {
            $query_two = "UPDATE table SET test = " . $color;
            mysql_query($query_two) or die(mysql_error());
            $number_of_results = mysql_num_rows($result);
        }
    }
    mysql_data_seek($result, 0);
}

mysql_data_seek

[djjjozsi]

and what is your aim with an update query like this ?

<?php
$test[] = "red";
$test[] = "green";
$test[] = "blue";
$test[] = "black";
$test[] = "white";

while ( $row = mysql_fetch_assoc( $result ) ) {
    foreach ( $test AS $value ) {
        $set[] = sprintf( "`field`='%s'" , $value ) ;
    } 
    $update_query = "update table SET " . implode( " , " , $set ) . sprintf( " WHERE `primaryKey`=%d" , $row["primaryKey"] ) ;
    mysql_query( $update_query ) OR die( mysql_error() );
    unset( $set );
    unset( $update_query );
} 

?>

[7724]

Thanks All