UBB.Developers Forums UBB.threads 7 Development How Do I? Generic page with list of member in specific group

<br />$query = mysql_query("SELECT U_Username, U_Number, U_Groups<br />                      FROM w3t_Users<br />                      WHERE U_Groups LIKE '%-10-%'<br />                      ORDER BY U_Username");<br /><br />if ($myrow = mysql_fetch_array($query)) {<br /><br />   echo "<table width=100% border=0><tr><td class=\"tdheader\" nowrap><center>Group 10</center></td></tr>\n";<br /><br />   do {<br /><br />     printf("<tr><td>%s</td></tr>\n",$myrow["U_Username"]);<br />   }<br /><br />while ($myrow = mysql_fetch_array($query));<br /><br />echo "</table><p>\n";<br />}<br />