drop down boxes function result set
Posted: Sat Mar 13, 2010 3:08 pm
Hi,
I am trying to load my drop down boxes from an array returned from a function that generates a result set. Is it possible. Using zend core on ibm i db2 database.
I am trying to load my drop down boxes from an array returned from a function that generates a result set. Is it possible. Using zend core on ibm i db2 database.
Code: Select all
function GetStatus() {
$sql = "SELECT CDDL01 FROM CMSLIBD.TRMCODPF WHERE CDSY = 'BC'
AND CDRT = 'CS'";
$stmt =DB2_PREPARE($conn, $sql) or die("db2_prepare failed<br>");
$result = DB2_EXECUTE($stmt);
if (!$result){
echo "broken";}
while($row = db2_fetch_assoc($stmt))
{
$data = print "{$row[CDDL01]}";
}
return $data;
}
?>
<?php
include("cms_functions.php");
$status =array();
$status = GetStatus();
.......
<!Transaction Status>
<li id="li_6" >
<label class="description" for="element_6">Transaction Status </label>
<?php //createDropdown($status, 'element_6'); ?>
<div>
<select class="element select small" id="element_6" name="element_6">
// <option value="" selected="selected"></option>
//<option value="2" >Second option</option>
// <option value="3" >Third option</option>
</select>
</div><p class="guidelines" id="guide_6"><small>Select Transaction Status</small></p>
</li>