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. NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ | |
[Tanya Dong Para Master] Perintah SQL untuk menamp... Jul 20th 2013, 02:57, by Rifki Fardian | [Tanya Dong Para Master] Perintah SQL untuk menampilkan misal 10 data terbaru, dengan database nama table kegiatan id_kegiatan,tgl_kegiatan,nama_kegiatan,tempat THX |
| | SORT DESC |
| | LIMIT 10 |
| | select column_names from tabel_kegiatan order by tgl_kegiatan desc limit 10 |
| | ambil data kegiatan urut dr yg tanggalnya terbaru (ORDER BY ... DESC) dibatasi 10 baris saja (LIMIT 10) |
| | OK THX BOS Brangkattt ^_^ |
| | kalau ada filed id yang primary dan auto increment order by id desc limit 10 |
| | SELECT * FROM kegiatan ORDER BY tgl_kegiatan DESC LIMIT 10 | | |
|
Tidak ada komentar:
Posting Komentar