PHP Indonesia - Facebook | PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ | |
|
agan agan gimana caranya menampilkan data yang ta... Oct 21st 2013, 08:49, by Alif Akbar Fitrawan | agan agan
gimana caranya menampilkan data yang tanggalnya selisih 1 hari dari sekarang saya coba
---------------------------------------------------------------------------------------- function record_count() { $this->load->database(); $Q = $this->db->query("SELECT * FROM tm_data WHERE DATE_SUB(NOW(), INTERVAL 1 DAY) <= tanggal)"); return $Q->num_rows(); } ----------------------------------------------------------------------------------------
muncul pesan error "Error Number: 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 ')' at line 1
SELECT * FROM tm_data WHERE DATE_SUB(NOW(), INTERVAL 1 DAY) <= tanggal)" |
| | tanda ')' yg terakhir fungsinya buat apa ya? | | |
|
Tidak ada komentar:
Posting Komentar