Jumat, 30 Agustus 2013

PHP Indonesia - Facebook: [TANYA] Mohon bantuannya master... saya ingin mena...

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/ 
Exotic travel ideas.

Searching for your next vacation destination? Subscribe to Off The Beaten Path, a newsletter featuring captivating locales to help you to plan your next trip.
From our sponsors
[TANYA] Mohon bantuannya master... saya ingin mena...
Aug 30th 2013, 16:52, by Indra Syafi'i

Indra Syafi'i 4:52pm Aug 30
[TANYA]
Mohon bantuannya master...
saya ingin menampilkan data berdasarkan semua kolom, jadi tidak hanya satu kolom, kira-kira query mysqlnya gimana yah...???
select * from table_A where [SEMUA KOLOM] like '%$cari%'
Terima kasih sebelumnya...

Miftah Al Arifin 5:02pm Aug 30
kolom yg dmaksud adlh field kn??! select * it kn sdh smw field

Indra Syafi'i 5:06pm Aug 30
klo tanpa where kan menampilkan semua data.
saya ingin mencari data, tapi tidak terfokus satu field, melainkan semua field.
asalakan ada kata yang saya cari, maka datanya muncul.
--------------------------------------------------------------------
select * from Table_A where Field_1 = '$cari' -> berdasarkan Field_1
--------------------------------------------------------------------
select *from Table_A where Field_2 = '$cari' -> berdasarkan Field_2
--------------------------------------------------------------------
nah saya ingin berdasarkan semua FIELD. where nya gimana?

Miftah Al Arifin 5:14pm Aug 30
oh maaf sy pkir td u/ memunculkn smw field, jd select * kn dh ckup... klo pngen carix it ksmw kolom, setau sy wherenya dtmbh OR

Bhie Phratama 5:19pm Aug 30
kl semua kolom ckup SELECT * FROM nm_table z..tp kl berdasar kolom tertentu y pk SELECT kolom1,kolom2,dst..FROM nm_table..

Miftah Al Arifin 5:21pm Aug 30
nah, maz bhie brfikir spt sy td :)

Indra Syafi'i 5:23pm Aug 30
Master Miftah Al Arifin : klo field na ada 50, masa saya bikin OR buat 50 field.
ada cara singkatnya ga?
-------------------------------------------------------------
select * from Table_A where Field_1 = '$cari' or Field_2 = '$cari' -> klo ada 50 field ? kan panjang banget... ada cara singkatnya ga?
-------------------------------------------------------------
Maaf udah bikin para master bingung... maklum... ane masih nubi... ;)

Gunawan Mujur Wibisono 5:25pm Aug 30
kl ada 50.. coba km pisah2 mana yg layak dicari.. mana yg tidak

Miftah Al Arifin 5:27pm Aug 30
maaf sy bkn master tp msh newbie jg, mlah lbh nubi dr anda :-),.. it stau sy, klo ad cra yg lbh ringkas, qta tunggu jwbn yg lain

Slamet Aprilianto 7:33pm Aug 30
Kalo nama kolomnya berpola, di akalin di phpnya aja. Itu tabel isinya apa ampe 50 kolom :o

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

Tidak ada komentar:

Posting Komentar