1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

<?php  //item details for adding item to BOM 
$formid=$_REQUEST['formid'];
require_once "inc/configure.php";

$cat=$_REQUEST['bomcategy'];

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