vietfancy
12-13-2009, 01:55 AM
$result = $vbulletin->db->query_read("SELECT * FROM schedule WHERE live = 1 ORDER BY DESC");
while($r = $vbulletin->db->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
while($r = $vbulletin->db->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