Grouping results

Hello All, How can I group database results in a foreach loop? I have a field_group column that can have a value or not. I want to read from the database then display results and if the results have a matching field_group, I want to have them group in the html. This is my current SQL. I am using MySQL. $Sql = "SELECT * FROM ".table_name.' GROUP BY Field_ID, Field_Group'; From this I want to be able to wrap the groups in a div and add a h3 with the group name. So if there are 5 entries in the BOB group, then the html would look like this. <input name="Field_Name1" />//empty Field_Group <div id="BOB">//Field_Group = BOB <input name="Field_Name2" /> <input name="Field_Name3" /> <input name="Field_Name4" /> <input name="Field_Name10" /> </div> <input name="Field_Name5" />//empty Field_Group <input name="Field_Name6" />//empty Field_Group <div id="Charlie">//Field_Group = Charlie <input name="Field_Name8" /> <input name="Field_Name9" /> <input name="Field_Name15" /> </div> Am I setting this up right? TIA Best, Karl DeSaulniers Design Drumm http://designdrumm.com