query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' ")) { while ($row = $result->fetch_assoc() ) { $stdd=$stdd. ""; } } $connect->close(); ?>
DESCRIPTION | CATEGORY | UOM | BALANCE IN STOCK | UNIT COST | STOCK VALUE | RE-ORDER LEVEL | QTY TO RE-ORDER |
---|---|---|---|---|---|---|---|
DESCRIPTION | CATEGORY | UOM | BALANCE IN STOCK | UNIT COST | STOCK VALUE | RE-ORDER LEVEL | QTY TO RE-ORDER | '.$str123.' | '; } else{ return ''.$str123.' | '; } } } require('connect/config.php'); $sql = "SELECT * FROM `items` LEFT JOIN `recievables` ON items.DESCRIPTION=recievables.DESCRIPTION LEFT JOIN `outgoingorders` ON items.DESCRIPTION=outgoingorders.DESCRIPTION WHERE DISCONTINUE = 'DISABLED' ORDER BY items.DESCRIPTION DESC"; $res = $conn->query($sql); while($row=$res->fetch_assoc()){ echo '
'.$row["UNITCOST"].' |