mysql_fetch_array problem!

[admin]

When I run the following statement, even though it returns the correct resultset

(i.e
for($index=1;$myrow= mysql_fetch_array($resultset);$index++){
echo $myrow["x"];
echo $myrow["y"];
echo $myrow["z"];
}
returns correct values!)

The x,y &z arays are empty. Whta seems to be the problem!!

#####################################
#
# CODE
#
#####################################



$resultset = mysql_query("SELECT x, y, z FROM table WHERE condition='satisfied'",$database);

for($index=1;$myrow= mysql_fetch_array($resultset);$index++){
$x[$index]=$myrow["x"];
$y[$index]=$myrow["y"];
$z[$index]=$myrow["z"];
}

#######################################

Regards,

Sacevoy ~