Re: Grouping results

Well, I figured it out. It took two queries. Probably a better way I'm not thinking about, but this works in case anyone needs/wants. Was hoping to do it all in the SQL statement I guess. $FieldGroups = $wpdb->get_results("SELECT DISTINCT Field_Group FROM ".table_name); foreach($FieldGroups as $FieldGroup) { $ReturnString .= '<h3>'.$FieldGroup->Field_Group.'</h3>'; $Fields = $wpdb->get_results($wpdb->prepare("SELECT * FROM ". table_name.' WHERE Field_Group=%s', $FieldGroup->Field_Group)); foreach($Fields as $i=>$Field) { $ReturnString .= /*Other code to build html*/ } } return $ReturnString; I am working on a WordPress site. Hence the $wpdb->get_results(). FYI, for those who aren't familiar. Best, Karl DeSaulniers Design Drumm http://designdrumm.com PS: Thanks teddy bear On Jul 22, 2015, at 11:19 PM, Karl DeSaulniers <karl@designdrumm.com> wrote: > 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 > > >