error number : 1064

Avatar
  • Answered
hi ,
i have a problem about syntax 1064

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 '`NULL` AND `semester`.`id_semester` = `absen`.`id_semester` AND `absen`.`id_seme' at line 4

SELECT `absen`.`id_absen`, `absen`.`tanggal`, `absen`.`absen`, `siswa`.`nis`, `siswa`.`nama`, `kelas`.`kelas` FROM `absen`, `siswa`, `kelas`, `semester` WHERE `siswa`.`id_kelas` = `kelas`.`id_kelas` AND `absen`.`nis` = `siswa`.`n IS NOT` `NULL` AND `semester`.`id_semester` = `absen`.`id_semester` AND `absen`.`id_semester` = '1' ORDER BY `absen`.`id_absen` DESC LIMIT 10

Filename: C:/xampp/htdocs/absensi2014/application/models/absen_model.php

Line Number: 34

please help me to fix it... Thanx
Avatar
johnpaulb-imhs1
Hello, Thank you for contacting us about a 1064 error. I looked at the information you provided, and it seems to be an issue with your single-quotation. I recommend reviewing your syntax for the correct opening and closing single-quotation. For example, it seems you are missing a closing (') on your n: `n IS NOT` Let us know if you have any further questions. Thank you, John-Paul