Article title in drop down

How do I get a list of published articles to display in a drop down? I found this article but it doesn't seem to be exactly what I am looking for. I only need the article title and only from a specified section/category. Thanks!

http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=5&t=11266&hilit=article+article+title&start=15

Hi vistech,

Yes that's a ChronoConnectivity post rather then ChronoForms. ChronoConnrctivity is designed to display list of entries from a table; in ChronoForms you have to code that yourself. It will be something like

<?php
if ( !$mainframe->isSite() ) { return; }
$db =& JFactory::getDBO();
$query = "
  SELECT `title`
    FROM `#__content`
    WHERE `catid` = 'xxx' AND `secid` = 'yyy' 
    ORDER BY `title` ;
";
$db->setQuery($query);
$titles = $db->loadResultArray();
foreach ( $titles as $title )  {
   echo "<div>$title</div>";
}
?>

Not checked and will need debugging.

Bob