function getetlist() { global $vbulletin; $classlist = $vbulletin->db->query_read(" SELECT toplist1.class_name AS class_name, toplist1.class_desc AS class_desc, toplist2.option1 AS option1, toplist2.option2 AS option2, toplist2.option3 AS option3, toplist2.option4 AS option4, toplist2.option5 AS option5, toplist2.option6 AS option6 FROM toplist1, toplist2 WHERE toplist1.id = toplist2.toplist1id ORDER BY toplist1.id, toplist2.option2 LIMIT 10 "); $ret_str = ''; $temp_str = ''; while ($classrow = $vbulletin->db->fetch_array($classlist)) { if ($classrow['class_name'] != $temp_str) { $ret_str .= " <tr> <td class=\"tcat\" colspan=\"6\"><b>" . $classrow['class_name'] . "</b></td> </tr> <tr> <td class=\"alt1\" colspan=\"6\">" . $classrow['class_desc'] . "</td> </tr> <tr> <td class=\"alt2\" width=\"10%\"><div class=\"smallfont\"><b>Option1</b></div></td> <td class=\"alt2\"><div class=\"smallfont\"><b>Option2</b></div></td> <td class=\"alt2\"><div class=\"smallfont\"><b>Option3</b></div></td> <td class=\"alt2\"><div class=\"smallfont\"><b>Option4</b></div></td> <td class=\"alt2\"><div class=\"smallfont\"><b>Option5</b></div></td> <td class=\"alt2\" width=\"45%\"><div class=\"smallfont\"><b>Option6</b></div></td> </tr> "; $temp_str = $classrow['class_name']; } $ret_str .= " <tr> <td class=\"alt1\">" . $classrow['option1'] . "</td> <td class=\"alt2\">" . $classrow['option2'] . "</td> <td class=\"alt1\">" . $classrow['option3'] . "</td> <td class=\"alt2\">" . $classrow['option4'] . "</td> <td class=\"alt1\">" . $classrow['option5'] . "</td> <td class=\"alt2\">" . $classrow['option6'] . "</td> </tr> "; } return $ret_str; } $timelist = getetlist();