How? :)

Let's say I have two fields TNum and AU. TNum is a <select><option>British<option>American<option>Canadian AU <input> name of an author. I want to sort them as follows. British Shakespeare American Joyce Samuels Twain Canadian Majors Kamboureli How do I get this to work in this code below? I want to echo TNum one time only and echo every AU. $news = mysql_query("select * from bookmarks ORDER by TNum,AU asc"); while ($mydata = mysql_fetch_object($news)) { if (...??) #when TNum occurs the first time, echo it once only. { $body .= "<b>".$mydata->TNum.":</b>"; } $body .= "<li>".$mydata->AU."</li>"; } ----------------------------------------------------------------------