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/ | |
 | Have An Idea?
Start developing and building it in our Product Management course in London.  | From our sponsors | | |
[ask] saya punya record di db dengan value date 20... Nov 9th 2013, 14:53, by Yudha Maulana | [ask] saya punya record di db dengan value date 2005-02-26 10:29:18.000 berupa 10 record dengan tahun berbeda nah untuk select data dimana > 2005 gmn ya? trims |
| | Where year>2005 |
| | gak bisa agan |
| | SELECT * FROM table WHERE YEAR(field_agan) > 2005; |
| | ^ oke gan bisa :D |
| | okeeeh... hehe |
| | pake fungsi year hehe udah keduluan :v |
| | gan kalo misalkan ane mau ambil secara otomatis tahun yang tersedia di db ane gmn gan? tp cuma 1 aja sebagai perwakilan |
| | Pake distinct | | |
|
Tidak ada komentar:
Posting Komentar