mplae question

[abitshort]

$result = query_read("SELECT * FROM  schedule WHERE live = 1 ORDER BY DESC");
while($r = fetch_array($result)){

$lala .= "<div>$r[instructor]</div>
      <div><b>$r[class]</b></div>
              <div><i>$r[level]</i></div>
              <div>$r[time] on $r[day]</div>";

}

 

it turns out to be like this:

 

Instructor A

Class A

Level A

Time A --- Day A

 

and

 

Instructor A

Class A

Level A

Time B --- Day B

 

How do i turn it to something like this:

 

Instructor A

Class A

Level A

Time A --- Day A and Time B --- Day B

[fenway]

You build your own structure in one pass, then output it in a second pass.