mysql_connect("dev.chillercity.com","chiller_db","coldstuff"); mysql_select_db("Chiller"); ?>
Chiller City Intranet
Inventory Entry Screen
Vendor
Manufacturer
$query = "select * from Manufacturers"; $result = mysql_query($query) or die(mysql_error()); ?>
while($row = mysql_fetch_array($result)) {?>
echo $row['Name'] ?>
}; ?>
Date Recieved
BOM #
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
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
27
28
29
30
31
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
Part #
Freight Co.
Condenser
$query = "select * from Condensers"; $result = mysql_query($query) or die(mysql_error()); ?>
while($row = mysql_fetch_array($result)) {?>
echo $row['Description'] ?>
}; ?>
Serial #
BOL #
Model
$query = "select * from Model"; $result = mysql_query($query) or die(mysql_error()); ?>
while($row = mysql_fetch_array($result)) {?>
echo $row['Description'] ?>
}; ?>
Owner
Controller
$query = "select * from Controllers"; $result = mysql_query($query) or die(mysql_error()); ?>
> while($row = mysql_fetch_array($result)) {?>
echo $row['Description'] ?>
}; ?>
RMA Number
Pump
Electrical
$query = "select * from Pumps"; $result = mysql_query($query) or die(mysql_error()); ?>
> while($row = mysql_fetch_array($result)) {?>
echo $row['Description'] ?>
}; ?>
$query = "select * from Electrical"; $result = mysql_query($query) or die(mysql_error()); ?>
> while($row = mysql_fetch_array($result)) {?>
echo $row['Description'] ?>
}; ?>
Extra Features, Modifcations or Comments