SQL = #*/sertifikat_idx.php
select p.nama, s.*, if(period_diff(date_format(now(), '%Y%m'),
to_days(now()) >= to_days(tgl_expire) as expired
from sertifikat_tkdn s, industri.perusahaan p
where s.id_perusahaan=p.id_perusahaan and kd_kelompok_barang='11' and
s.tgl_validasi is not null and period_diff(date_format(now(), '%Y%m'),
to_days(now()) <= to_days(tgl_expire)
order by tanggal_sertifikat desc, no_tanda_sah desc


Error = 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 'from sertifikat_tkdn s, industri.perusahaan p where s.id_perusahaan=p.id_perusah' at line 4 [ErrCode = 1064] at /var/www/html/tkdn/wisanggeni/classes/TQuery.class.php line 97

SQL = #*/sertifikat_idx.php
select p.nama, s.*, if(period_diff(date_format(now(), '%Y%m'),
to_days(now()) >= to_days(tgl_expire) as expired
from sertifikat_tkdn s, industri.perusahaan p
where s.id_perusahaan=p.id_perusahaan and kd_kelompok_barang='11' and
s.tgl_validasi is not null and period_diff(date_format(now(), '%Y%m'),
to_days(now()) <= to_days(tgl_expire)
order by tanggal_sertifikat desc, no_tanda_sah desc limit 260,20


Error = 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 'from sertifikat_tkdn s, industri.perusahaan p where s.id_perusahaan=p.id_perusah' at line 4 [ErrCode = 1064] at /var/www/html/tkdn/wisanggeni/classes/TQuery.class.php line 97

Website P3DN
Loading the player ...

Video lainnya...