Multiple MYSQL queries vs. Multiple php foreach loops

[ShellyS]

Database structure:\[code\]id galleryId type file_name description1 `artists_2010-01-15_7c1ec` `image` `band602.jpg` `Red Umbrella Promo`2 `artists_2010-01-15_7c1ec` `image` `nov7.jpg` `CD Release Party`3 `artists_2010-01-15_7c1ec` `video` `band.flv` `Presskit`\[/code\]I'm going to pull images out for one section of an application, videos on another, etc. Is it better to make multiple mysql queries for each section like so:\[code\]$query = mysql_query("SELECT * FROM galleries WHERE galleryId='$galleryId' && type='image');\[/code\]...Or should I be building an associative array and just looping through the array over and over whenever I need to use the result set?Thanks for the thoughts.