$sql = "SELECT $topicsColumn[tid],
$topicsColumn[topictext]
FROM $topicsTable
ORDER BY $topicsColumn[topictext]";$sql = "SELECT $topicsColumn[tid],
$topicsColumn[topictext],
$topicsColumn[topicname]
FROM $topicsTable
ORDER BY $topicsColumn[topictext]";for (; !$result->EOF; $result->MoveNext())
{
$topics[] = array('id' => $result->fields[0],
'name' => $result->fields[1],
'selected' => ($result->fields[0] == $currentTopic));
}for (; !$result->EOF; $result->MoveNext())
{
if(pnSecAuthAction(0, 'Topics::Topic', $result->fields[2]."::".$result->fields[0], ACCESS_READ)) {
$topics[] = array('id' => $result->fields[0],
'name' => $result->fields[1],
'selected' => ($result->fields[0] == $currentTopic));
}
}Template courtesy of Designs By Darren.