Needle in haystack only found once

[moboter]

I cant see a fault and the values exit mysql_numrows also gives me 2
the values are integers in the db.
I get 2 result running the query in the phpmyadmin
query is

$army=mysql_query("select size from boots where height=102010 and leather='y' or height=107505 and leather='y'");

$result=mysql_fetch_array($army);

if (in_array(102010, $result)) {
    echo "Got 102010";
}
if (in_array(107505, $result)) {
    echo "Got 107505";
}

[laserlight]

You need to call mysql_fetch_array() again to get the next row in the result set.

[moboter]

and there is now way arround it?
i wated to assign a variable to the pattern that was found

if (in_array(102010, $result)) {
    echo "Got 102010";
$group=1;
}
if (in_array(107505, $result)) {
    echo "Got 107505";
$group=2;
} 

but when I have to recall the mysql_fetch_array only one of the variables gets assigned a value (the second one). Is there a different way ?

[laserlight]

You might do something like this:

$result = mysql_query("SELECT size FROM boots WHERE height IN (102010, 107505) AND leather='y'");
$sizes = array();
while ($row = mysql_fetch_assoc($result)) {
    $sizes[] = $row['size'];
    echo 'Got ' . $row['size'] . "<br />\n";
}