think this is what you want ---- $i = 0; $result = mysql_query("SELECT jazz FROM funk WHERE foo='bar'") while($music = mysql_fetch_array($result)) { $funk_music[$i] = $music[0]; $I++; } ok...sorry to ask a stupid question but.... $result = mysql_query("SELECT jazz FROM funk WHERE foo='bar'") but where do you go from there. How would you iterate through the array a row at a time, doing your thing as you go along? thanks, jamie