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/ | |
|
Permisi master mau tanya "select * from modul whe... Nov 3rd 2013, 05:39, by Danang Vai Kurniawan | Permisi master mau tanya
"select * from modul where aktif='Y' and urutan='1'" dari skrip diatas kalo kita pengen nampilin urutan 1 sampai 5 gt gmn ? |
| | "SELECT * FROM modul WHERE aktif='Y' AND urutan BETWEEN 1 AND 5"
btw 'urutan' itu nama field?, apa maksudnya ..
"SELECT * FROM modul WHERE aktif='Y' LIMIT 5"
.. ato..
"SELECT * FROM modul WHERE aktif='Y' ORDER BY urutan LIMIT 5"
tau deh.. ane gak tau koding cuman asal koming...
lebih enaknya dikasih contoh data tabelnya seperti apa, dan hasil yg diinginkan seperti apa.. cmiiw ^_^V |
| | mungkin seperti ini urutan >= 1 and urutan <=5 |
| | select * from modul where aktif='Y' order by urutan asc limit 1,5 |
| | select * from modul where aktif='Y' order by urutan asc limit 1,5 |
| | "select * from modul where aktif='Y' and urutan>=1 and urutan<=5" |
| | makasi ane coba dulu gan | | |
|
Tidak ada komentar:
Posting Komentar