query($query); ?>

Reports & Products: By Topic

Click on the first letter of the topic you are interested in OR scroll through the list to locate and click on the topic. You will be provided a list from which to select products/chapters/reports that contain information on that topic.

    fetch_assoc()) { $topicName = $row["WebTopicName"]; $curFirstChar = strtoupper(substr($topicName, 0, 1)); if (($lastFirstChar == " ") || ($lastFirstChar != $curFirstChar)) { echo "
  • " . $curFirstChar . "
  • "; $lastFirstChar = $curFirstChar; } } echo "
"; // resetting isn't working, so do query again //mysql_data_seek($result, 0); $result->free(); $query = "SELECT WebTopicNickname, WebTopicName FROM WebTopics ORDER BY WebTopicName" ; $result = $conn->query($query); $lastFirstChar = " "; while($row = $result->fetch_assoc()) { $topicName = $row["WebTopicName"]; $curFirstChar = strtoupper(substr($topicName, 0, 1)); if (($lastFirstChar == " ") || $lastFirstChar != $curFirstChar) { if ($lastFirstChar != " ") { // Close last letter, if necessary echo "

"; } // Start new letter echo "

" . $curFirstChar . "

"; echo ""; } else { echo mysql_error(); } $result->free(); $conn->close(); ?>