MENU

SELECT GROUP_CONCAT(accno,' ') FROM koleksi 
            WHERE perpus='pertanian'
              AND penerbit='Australia Vice-Chancellors' Committee'
              AND tahun='1975'
              AND jilid=''
              AND edisi=''
              AND judul='A Course manual in the agronomy of annual crops'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Committee' AND tahun='1975' AND jilid='' ' at line 3

SELECT barcode FROM koleksi
        WHERE perpus='pertanian'
          AND penerbit='Australia Vice-Chancellors' Committee'
          AND tahun='1975'
          AND jilid=''
          AND edisi=''
          AND judul='A Course manual in the agronomy of annual crops'
        ORDER BY barcode

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Committee' AND tahun='1975' AND jilid='' AND edisi' at line 3

SELECT barcode FROM koleksi 
        WHERE perpus='pertanian'
          AND penerbit='Australia Vice-Chancellors' Committee'
          AND tahun='1975'
          AND jilid=''
          AND edisi=''
          AND judul='A Course manual in the agronomy of annual crops'
        ORDER BY barcode

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Committee' AND tahun='1975' AND jilid='' AND edisi' at line 3

SELECT perpus, letak, COUNT(barcode) AS jumlah 
            FROM koleksi 
            WHERE perpus='pertanian' 
              AND status='Ada'
              AND penerbit='Australia Vice-Chancellors' Committee'
              AND tahun='1975'
              AND jilid=''
              AND edisi=''
              AND judul='A Course manual in the agronomy of annual crops'
            GROUP BY letak

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Committee' AND tahun='1975' AND jilid='' ' at line 5

SELECT COUNT(*) FROM koleksi 
            WHERE perpus='pertanian' AND status='Rusak'
              AND penerbit='Australia Vice-Chancellors' Committee'
              AND tahun='1975'
              AND jilid=''
              AND edisi=''
              AND judul='A Course manual in the agronomy of annual crops'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Committee' AND tahun='1975' AND jilid='' ' at line 3

SELECT COUNT(*) FROM koleksi 
            WHERE perpus='pertanian' AND status='Hilang'
              AND penerbit='Australia Vice-Chancellors' Committee'
              AND tahun='1975'
              AND jilid=''
              AND edisi=''
              AND judul='A Course manual in the agronomy of annual crops'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Committee' AND tahun='1975' AND jilid='' ' at line 3

SELECT COUNT(barcode) AS jumlah FROM koleksi 
        WHERE perpus='pertanian' AND status='Dipinjam'
          AND penerbit='Australia Vice-Chancellors' Committee'
          AND tahun='1975'
          AND jilid=''
          AND edisi=''
          AND judul='A Course manual in the agronomy of annual crops'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Committee' AND tahun='1975' AND jilid='' AND edisi' at line 3