Complex Array

jc94062

I have a query, as below that makes no sense.

$adminquery=mysql_query("SELECT id FROM table WHERE id='$id'",$db);
$numgames = mysql_num_rows($adminquery);
while ($games=mysql_fetch_array($adminquery)) {
$id[] = $games["id"];
}
for ($i=0;$i<=$numgames-1;$i++) {
echo "$id[$i]<br>";
if ($id[$i] == "$agame") {$aaccess = '1';} else {$aaccess = '0';}
}

This outputs
1
2
3
4
to the browser, which is good, but it always sets $aaccess to 0.

If I change the if line to
if ($id[1] == "$agame") then it works okay (id[1] is 2, the value I give $agame) but this makes no sense as the echo proves that the for() array works okay.

I've been messing about with this for hours, as has a friend but neither of us can make it work and its driving me nuts!

Any help much much appreciated!

Anon

If you're just looking to see if one of the id's is equal to $agame then break out of the for loop when it is equal.

for ($i = 0; $i <= $numgames - 1; $i++) {
if ($id[$i] == $agame) {
$aaccess = 1;
break;
}
else {
$aaccess = 0;
}
}

If you're using php4 then you can also use the array_search() function to check if the value $agame is in the id array.

jc94062

Ah!

Thanks LOADS! It works now :-)

I was checking for them all, so it would always set 3 out of the 4 as false!

cthulhu

Just seems like the if should be
if ($id[$i] == "$agame" and $aaccess == '0') {$aaccess = '1';} else {$aaccess = '0';}
};

otherwise a later fail will negate a success.

jc94062

Slight problem with that, if has to run in a for statement.
But I got around it by setting aaccess to 0 before the for statement and then checking the value of aaccess afterwards, if even one of the values was true aaccess went to 1 :-)