PHP Indonesia - Facebook: Nama isinya "Saya", tanggal_awal isinya "201...

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/

Mobile Game Development Course Learn how to create awesome HTML5 games that run on iPhone, iPad, Android and Desktop! Sign up today for this $99 online course. From our sponsors

Nama isinya "Saya", tanggal_awal isinya "201... Oct 4th 2013, 03:49, by Delfrinando Pranata Delfrinando Pranata 3:49am Oct 4 <ASK> Nama isinya "Saya", tanggal_awal isinya "2013-01-01" dan tanggal_akhir isinya "2013-01-10". Apa querynya jika kita menginputkan tanggal "20-01-09", maka data "Saya" akan keluar?? <fixed date, jadi gak pake betwen>.. mohon bantuannya.. Edy Zragentina Subandono 3:51am Oct 4 pertanyaanya aja biki stress... mungkin bawah ane tau... :D Candra Nur Ihsan 3:56am Oct 4 tanggal_awal=date("Y-m-d',strtotime(tanggal)) Danura Aditya 3:56am Oct 4 Ini Pie Yo maksudnya Delfrinando Pranata 3:57am Oct 4 Jadi ada tabel A. _________________ | nama | awal | akhir | ------------------------------ | saya | 2013-01-01 | 2013-01-10| ---------------------------------------------- Apa querinya jika kita masukin tanggal "2013-01-09" di clausa where, maka data diatas itu muncul. Gitu. Edy Zragentina Subandono 4:04am Oct 4 SELECT Kolom FROM tabel WHERE awal=nilainya AND akhir=nilainya Cahya Dsn 4:04am Oct 4 tanggal awal dan tanggal akhir tipe data di tabel-nya apa? DATE atau VARCHAR/CHAR ? Ovix Dodon 4:05am Oct 4 kaya'nya tetep harus between deh, cos key pencariannya itu berada diantara value yg ada ...[awal] & [akhir] Edy Zragentina Subandono 4:06am Oct 4 Setuju ^ Dwi Wahyu 4:06am Oct 4 where tgl 1>= date1 and tgl1 <= date2 tipe field tgl bisa datetime atau varchar.. podo ae.. Aris Sulistiana 4:07am Oct 4 awal >= nilai AND akhir <= nilai Delfrinando Pranata 4:09am Oct 4 Owwhhhh. Terimakasih atas sarannya, nanti dicobain

You are receiving this email because you subscribed to this feed at blogtrottr.com. If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions