Something

$qry = "select id,z,x,c from qwe";
$pointer = mysql_query($qry);

while ($result = mysql_fetch_assoc($pointer)) {
$newarray[$result[$id]] = $result[$z];
$newarray[$result[$id]] = $result[$x];
$newarray[$result[$id]] = $result[$c];
}