1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

<option value=""></option>

<?php //selection for adding operation
$formid=$_REQUEST['formid'];
require_once "inc/configure.php";

$refid=(int)$_REQUEST['refid'];


    //$sql = "SELECT * from inv_$cat where verified=1 order by itemno";
    $sql = "SELECT * from master_operation where parent_refid = :refid";        
//echo $sql;    
    $sth = $dbh->prepare($sql);
    $sth->execute( array(':refid'=>$refid) );
    //echo $sth->getSQL();
    while($row = $sth->fetch() ){?>
    <option value="<?=$row['refid']?>"><?=$row['code']?> - <?=$row['codedesc_'.SYS_LANG]?></option>
<?php }    unset($sth);?>