[ask]php mysql query barang

[huhui]

table  group_barang

Code:

DROP TABLE IF EXISTS `group_barang`;
CREATE TABLE `group_barang` (
  `id` bigint(10) NOT NULL auto_increment,
  `code` char(10) collate latin1_general_ci NOT NULL,
  `name` char(40) collate latin1_general_ci default NULL,
  UNIQUE KEY `code` (`code`),
  UNIQUE KEY `code_2` (`code`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# Dumping data for table group_barang
#

INSERT INTO `group_barang` VALUES (1,'KOM','Komputer');
INSERT INTO `group_barang` VALUES (2,'SER','Server CP');
INSERT INTO `group_barang` VALUES (3,'TSC','Touch Scr');
INSERT INTO `group_barang` VALUES (4,'PRT','Printer');
INSERT INTO `group_barang` VALUES (5,'OHP','Projector');
INSERT INTO `group_barang` VALUES (6,'PHC','Photcopy');
INSERT INTO `group_barang` VALUES (7,'INF','Infocus');
INSERT INTO `group_barang` VALUES (8,'AC','Air Con');
INSERT INTO `group_barang` VALUES (9,'KAF','Fixed Fan');
INSERT INTO `group_barang` VALUES (10,'KAP','Portbl fan');
INSERT INTO `group_barang` VALUES (11,'DIS','Dispenser');
INSERT INTO `group_barang` VALUES (12,'TEL','Telephone');
INSERT INTO `group_barang` VALUES (13,'TV','Televisio');
INSERT INTO `group_barang` VALUES (14,'CD','Player');
INSERT INTO `group_barang` VALUES (15,'FLD','Flashdisc');
INSERT INTO `group_barang` VALUES (16,'CAM','Camera');
INSERT INTO `group_barang` VALUES (17,'SW','switch un');
INSERT INTO `group_barang` VALUES (18,'EXT','Extension');
INSERT INTO `group_barang` VALUES (19,'SCA','Scanner');
INSERT INTO `group_barang` VALUES (20,'AMP','Amplifier');
INSERT INTO `group_barang` VALUES (21,'SP','Speakers');
INSERT INTO `group_barang` VALUES (22,'MIC','Microphon');
INSERT INTO `group_barang` VALUES (23,'FAX','machine');
INSERT INTO `group_barang` VALUES (24,'1','Lemari Arsip');
INSERT INTO `group_barang` VALUES (25,'2','Lemari Lain');
INSERT INTO `group_barang` VALUES (26,'3','Filling Cabinet');
INSERT INTO `group_barang` VALUES (27,'4','Cabinet Lain');
INSERT INTO `group_barang` VALUES (28,'5','Wall Unit Shelf Cabinet');
INSERT INTO `group_barang` VALUES (29,'6','Bookshelf Tinggi');
INSERT INTO `group_barang` VALUES (30,'7','Bookshelf Kecil');
INSERT INTO `group_barang` VALUES (31,'8','Meja Komputer');
INSERT INTO `group_barang` VALUES (32,'9','Meja Executive');
INSERT INTO `group_barang` VALUES (33,'10','Meja Kantor');
INSERT INTO `group_barang` VALUES (34,'11','Meja Dosen');
INSERT INTO `group_barang` VALUES (35,'12','Meja Kayu Lain');
INSERT INTO `group_barang` VALUES (36,'13','Meja Lab Putih');
INSERT INTO `group_barang` VALUES (37,'14','Meja Gambar Besar');
INSERT INTO `group_barang` VALUES (38,'15','Meja Gambar Kecil');
INSERT INTO `group_barang` VALUES (39,'16','Meja Trolley');
INSERT INTO `group_barang` VALUES (40,'17','Meja Seminar');
INSERT INTO `group_barang` VALUES (41,'18','Meja Telephone');
INSERT INTO `group_barang` VALUES (42,'19','Meja Dispenser');
INSERT INTO `group_barang` VALUES (43,'20','Meja Kopi');
INSERT INTO `group_barang` VALUES (44,'21','Meja Lain');
INSERT INTO `group_barang` VALUES (45,'22','Meja Reception');
INSERT INTO `group_barang` VALUES (46,'23','Meja Executive');
INSERT INTO `group_barang` VALUES (47,'24','Kursi Executive');
INSERT INTO `group_barang` VALUES (48,'25','Sofa Set');
INSERT INTO `group_barang` VALUES (49,'26','Kursi kantor');
INSERT INTO `group_barang` VALUES (50,'27','Kursi Kuliah');
INSERT INTO `group_barang` VALUES (51,'28','Kursi Lipat');
INSERT INTO `group_barang` VALUES (52,'29','Kursi Unikom');
INSERT INTO `group_barang` VALUES (53,'30','Kursi Hijau');
INSERT INTO `group_barang` VALUES (54,'31','Kursi Lain');
INSERT INTO `group_barang` VALUES (55,'32','Lab. Stool Tinggi');
INSERT INTO `group_barang` VALUES (56,'33','Lab. Stool Pendek');
INSERT INTO `group_barang` VALUES (57,'34','Lab. Stool Baru');
INSERT INTO `group_barang` VALUES (58,'35','Wh Bd.Bes. Pakai Roda');
INSERT INTO `group_barang` VALUES (59,'36','Wh Bd Kec di Dinding');
INSERT INTO `group_barang` VALUES (60,'37','Soft Board Besar');
INSERT INTO `group_barang` VALUES (61,'38','Soft Board Kecil');
INSERT INTO `group_barang` VALUES (62,'39','Jam Dinding');
INSERT INTO `group_barang` VALUES (63,'40','Photoset SBY,JK');
INSERT INTO `group_barang` VALUES (64,'41','Partitions Table');
INSERT INTO `group_barang` VALUES (65,'42','Fire Extinguis');
INSERT INTO `group_barang` VALUES (66,'43','Asbak');
INSERT INTO `group_barang` VALUES (67,'44','Other Items');
INSERT INTO `group_barang` VALUES (68,'45','Lab Specific Equipment');

table
transaction

Code:

DROP TABLE IF EXISTS `transaction`;
CREATE TABLE `transaction` (
  `id` bigint(10) NOT NULL auto_increment,
  `no_equip_label` varchar(20) collate latin1_general_ci NOT NULL default '',
  `code_room` varchar(10) collate latin1_general_ci default NULL,
  `code_barang` varchar(10) collate latin1_general_ci default NULL,
  `condition_brg` char(1) collate latin1_general_ci default NULL,
  `date_label` date default NULL,
  `spec` text collate latin1_general_ci,
  PRIMARY KEY  (`id`,`no_equip_label`),
  UNIQUE KEY `no_equip_label` (`no_equip_label`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# Dumping data for table transaction
#

INSERT INTO `transaction` VALUES (1,'3201/KOM/01','3201','KOM','B','2008-10-02','KOMPUTER-1\r\nECS-L7S7A2\r\nProc:Atlon 1200\r\nMem:128 Mb\r\nHdd:Seagate 20 Gb\r\nVGA:Sis\r\n');
INSERT INTO `transaction` VALUES (2,'3201/KOM/02','3201','KOM','B','2008-05-02','KOMPUTER-2\r\nK7SEM\r\nProc:Duron 1200\r\nMem:128\r\nHdd:Seagate 20 Gb\r\nVga Onboard\r\n');
INSERT INTO `transaction` VALUES (3,'3206/KOM/01','3206','KOM','B','2005-10-10','KOMPUTER-6\r\nABIT-1A\r\nProc:Duron 650\r\nMem:128 Mb\r\nHdd:Quntum 40 Gb\r\nVga: S-3\r\n');
INSERT INTO `transaction` VALUES (4,'3205/KOM/01','3205','KOM','B','2007-12-05','KOMPUTER PENTIUM IV');
INSERT INTO `transaction` VALUES (8,'3201/PRT/01','3201','PRT','B','2008-04-12','PRINTER\r\nCannon BJC-2100SP\r\n');
INSERT INTO `transaction` VALUES (9,'Y101/KOM/01','Y101','KOM','B','2005-10-10','KOMPUTER-1\r\nECS-L7S7A2\r\nProc:Atlon 1200\r\nMem:128 Mb\r\nHdd:Seagate 20 Gb\r\nVGA:Sis\r\n');
INSERT INTO `transaction` VALUES (10,'Y101/KOM/02','Y101','KOM','B','2003-10-10','KOMPUTER-2\r\nK7SEM\r\nProc:Duron 1200\r\nMem:128\r\nHdd:Seagate 20 Gb\r\nVga Onboard\r\n');
INSERT INTO `transaction` VALUES (11,'Y101/SER/01','Y101','SER','B','2003-10-10','SERVER -1\r\nECS-NFORCE-3\r\nProc:Atlon 2000\r\nMem:512 Mb\r\nHdd:Seagate 40 Gb\r\nVga: GForce\r\n');
INSERT INTO `transaction` VALUES (12,'Y101/SER/02','Y101','SER','B','2005-10-10','SERVER -2\r\nAB9-Pro\r\nProc:Intel 2800\r\nMem:512 Mb\r\nHdd:Seagate 40 Gb\r\nVga: Onboard\r\n');
INSERT INTO `transaction` VALUES (13,'Y101/SWT/01','Y101','SWT','B','2003-10-10','SWITCH\r\nECOM-16 Port\r\n');
INSERT INTO `transaction` VALUES (14,'Y101/PRT/01','Y101','PRT','B','2005-10-10','PRINTER\r\nCannon BJC-2100SP\r\n');
INSERT INTO `transaction` VALUES (30,'3101/KOM/01','3101','KOM','B','2008-05-10','Proc:Intel Pentium 4\r\nDualcore\r\nMemory 1024 Mb\r\nHardisk 200 Gb\r\n');
INSERT INTO `transaction` VALUES (31,'3101/KOM/02','3101','KOM','B','2008-10-10','Proc:Intel Pentium 4\r\nDual Core\r\nMemory : 512 Mb\r\nHarddisk: 80 Mb\r\n');
INSERT INTO `transaction` VALUES (37,'Y101/KOM/05','Y101','KOM','B','2008-04-25','komputer baik aja');
INSERT INTO `transaction` VALUES (38,'1001/KOM/01','1001','KOM','B','2008-04-26','Intel Pentium 5 ');
INSERT INTO `transaction` VALUES (39,'1001/KOM/02','1001','KOM','B','2008-04-26','Amd 64 memory 1024 Mb');
INSERT INTO `transaction` VALUES (40,'1002/KOM/01','1002','KOM','B','2008-04-26','Laptop');
INSERT INTO `transaction` VALUES (41,'1202/KOM/01','1202','KOM','B','2008-04-27','ION LIVEO S110');
INSERT INTO `transaction` VALUES (42,'1202/KOM/02','1202','KOM','B','2008-04-27','ION LIVEO S110');
INSERT INTO `transaction` VALUES (43,'1202/KOM/03','1202','KOM','B','2008-04-27','ION LIVEO S110');

saya mau mengetahui jumlah barang dalam 1 ruangan

querynya seperti apa yah

query saya seperti ini tapi kaga jalan

Code:

<h3>REKAP DATA</h3>
<table border="1" width="100%">
<tr><td>No</td> <td>RUANG</td>
<td>KOMPUTER</td>
<td>AC</td>
</tr>
<?php
error_reporting&#40;E_ALL&#41;;
include "koneksi&#46;php";
$sql = "SELECT * from transaction GROUP BY code_room";
$query = mysql_query&#40;$sql&#41; or die &#40;"ERROR0"&#41;;
while&#40;$baca = mysql_fetch_array&#40;$query&#41;&#41;
&#123;
$x++;
echo "<tr><td> $x </td>";
echo "<td> $baca[code_room&#93;</td>";

$kom=mysql_query&#40;"SELECT code_barang FROM transaction WHERE code_room = '"&#46;$baca['code_room'&#93;&#46;"'"&#41; or die &#40;"ERROR1" &#46;mysql_error&#40;&#41;&#41;;
$jkom=0;

while&#40;$barang=mysql_fetch_array&#40;$kom&#41;&#41;
&#123;
$kode=mysql_query&#40;"SELECT code FROM group_barang"&#41; or die &#40;"ERROR2"&#41;;
$jumkode=mysql_num_rows&#40;$kode&#41;;
$a=1;
while&#40;$kdbrg=mysql_fetch_array&#40;$kode&#41;&#41;
&#123;
if &#40;$barang['code_barang'&#93; == $kdbrg['code'&#93;&#41; 
&#123;$jkom[$a&#93;=$jkom[$a&#93;+1;&#125;
echo " $jkom[$a&#93;";
$a++;

&#125;
&#125;
for &#40;$i=1; $i <= $jumkode; $i++&#41;
&#123;
echo "<td>$jkom[1&#93;$jkom[2&#93;</td>";
&#125;
&#125;
?>
</table>
help2

[webmaster]

sori tadi lagi sama bos, jadi smpet tertunda. ..  :?

sebelumna tambahin satu table lagi, jalankan SQL query di bawah ini:

Code:

CREATE TABLE `group_room` (
  `id` bigint(10) NOT NULL auto_increment,
  `code` char(10) collate latin1_general_ci NOT NULL default '',
  `name` char(40) collate latin1_general_ci default NULL,
  UNIQUE KEY `code` (`code`),
  UNIQUE KEY `code_2` (`code`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=9 ;

INSERT INTO `group_room` VALUES (1, '3201', 'ruang 3201');
INSERT INTO `group_room` VALUES (2, '3206', 'ruang 3206');
INSERT INTO `group_room` VALUES (3, '3205', 'ruang 3205');
INSERT INTO `group_room` VALUES (4, 'Y101', 'ruang Y101');
INSERT INTO `group_room` VALUES (5, '3101', 'ruang 3101');
INSERT INTO `group_room` VALUES (6, '1001', 'ruang 1001');
INSERT INTO `group_room` VALUES (7, '1002', 'ruang 1002');
INSERT INTO `group_room` VALUES (8, '1202', 'ruang 1202');

nah ni script gw, klik disini:

http://www.dremi.info/web/tips/idik-php.html

semoga beruntung wkwkwkwkwkwkw :lachtot:  

[huhui]

ok bro saya coba dulu yah

thx bantuannya!