This is another guess as to what you are trying to do. Hope it helps.
Code:
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();