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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
var hide_empty_list=true;
addListGroup("vehicles", "car-makers");
<?
$dbh = mysql_connect("localhost", "man", "we11d0ne");
if (!$dbh) {
die('Could not connect: ' . mysql_error());
}
$selected = mysql_select_db("oneERP",$dbh)
or die("Error");
?>
<?
$sql = "select * from INV_CATEGORY_MAJ";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
?>
addList("car-makers", "<?=$row{'majcatname'}?>", "<?=$row{'majcatid'}?>", "<?=$row{'majcatid'}?>");
<?
}
?>
<?
$sql = "select * from INV_CATEGORY_MAJ";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
?>
addList("<?=$row{'majcatid'}?>", "Select sub category", "", "dummy-<?=$row{'majcatname'}?>");
<?
$sqls = "select * from INV_CATEGORY_SUB where majcatid = ". $row{'majcatid'};
$results = mysql_query($sqls);
while ($rows = mysql_fetch_array($results,MYSQL_ASSOC))
{
?>
addList("<?=$rows{'majcatid'}?>", "<?=$rows{'subcatname'}?>", "<?=$rows{'subcatname'}?>", "<?=$rows{'subcatname'}?>");
<?
}
}
?>
|