I have chronoforms' form, i need to fill some textbox and list with data from another table
can anyone help me?
can anyone help me?
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 150px;">Representative:</label>
<select class="cf_inputbox" id="select_23" size="1" title="" name="Rep">
<option value="">Choose Option</option>
<option value="Ross">Ross</option>
<option value="Kevin">Kevin</option>
<option value="Jan">Jan</option>
<option value="Bob">Bob</option>
<option value="Julianne">Julianne</option>
</select>
</div>
<div class="cfclear"> </div>
</div>
<div class="form_item">
<div class="form_element cf_dropdown">
<label class="cf_label" style="width: 150px;">Representative:</label>
<select class="cf_inputbox" id="select_23" size="1" title="" name="Rep">
<option value="">Choose Option</option>
<?php
jimport( 'joomla.application.component.controller' );
global $mainframe;
$database =& JFactory::getDBO();
$database->setQuery("SELECT RepFirstName FROM ou9g_chronoforms_Reps ORDER BY RepFirstName");
$cconnections = $database->loadObjectList();
foreach($cconnections as $cconnection){
echo "<option value=\"" . $cconnection->RepFirstName . "\">" . $cconnection->RepFirstName . "</option>\n";
}
?>
</select>
</div>
<div class="cfclear"> </div>
</div>