1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
<? require("inc/configure.php"); require("inc/global.php"); require("inc/checklogin.php"); if ($logged_in == 0) { //echo 'Not logged in. <a href="login.php">Login</a>'; header('Window-target: _parent'); header('Location: login.php'); exit(); } ?> <?php $q=$_GET["q"];
$sql="select * from INV_PRODUCT a, INV_UOM b where a.uomid = b.uomid and a.prodid = ".$q." and a.status = 1";
$result = mysql_query($sql); if ($row = mysql_fetch_array($result)) { echo "(".$row['uom'].")"; echo " <b>". $row['prodname'] ."</b>"; echo "<input type='hidden' class='content' size='10' name='uomid' value='".$row['uomid']."'>";
} mysql_close($con); ?>
|