select * from nama_tabel where nama_field='$nama_variabel' order by 
nama_field asc

Semoga membantu,
Handoko Luwanto

----- Original Message ----- 
From: Toha Tazix
To: [email protected]
Sent: Wednesday, March 28, 2007 6:43 AM
Subject: [ITCENTER] Tanya Script MySql....


Hi ITers...

Saya punya suatu script mysql, dimana variabel kondisi WHERE ingin diberikan
setelah pernyataan query SQL dieksekusi.

pernah coba di PL/SQL oracle seperti ini:

select nama,alamat
from customer
where nama=&nama;

Nah untuk mysql, variabel kondisi &nama itu kira2 bagaimana?
Mohon pencerahannya dari para ITers...

Terimakasih sebelumnya.

-- 
Regards

Toha




-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##

## Jaket ITCENTER tersedia di http://shop.itcenter.or.id 
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ITCENTER/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/ITCENTER/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[EMAIL PROTECTED] 
    mailto:[EMAIL PROTECTED]

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 

Kirim email ke