-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
ed - wrote:
| Mau tanya, saya punya query sbb:
|
| $query3="Select * from ket_proyek where status like
| '%progress%'"
|
|
| $hasil3=mysql_db_query ($db,$query3,$koneksi);
|
|
| while
| (list($idproject3,$working_date,$pij,$job,$ket,$status)=
| mysql_fetch_row($hasil3))
| {
| echo "<tr>";
| echo "<td bgcolor=#FF9933 width=30%>Id
| Project</td>\n";
| echo "<td bgcolor=#FF9933
| width=70%>$idproject3</td>";
| echo "</tr>";
| }
|
|
| hasil dari id projectnya menghasilkan 6 record yaitu:
| Id Project: 01
| Id Project: 01
| Id Project: 01
| Id Project: 01
| Id Project: 02
| Id Project: 03
|
| Pertanyaannya bagaimana caranya kalau saya ingin
| mengambil data tsb
| utk dijadikan variabel, tapi data yang diambil hanya
| 3, yaitu 01,02,03.
| Jadi id project yang sama tdk diambil semuanya.
| Data tsb ingin dipakai utk query ke tabel lainnya.
|
| $query4="Select * from proyek where id_project =
| '$idproject3'";
cobain dgn query 'SELECT DISTINCT...'
detail bs dilihat mysql manual
- --
adi s
- -----
ERROR 103: Dead mouse in hard drive.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD4DBQFBAIsmBSBLn1IMGcgRAlhtAJ9euNhogYbjBgV4X+r5n47J6FgntACYza2r
ga3BaxZdsmJ74YLcJh+d0w==
=3RVm
-----END PGP SIGNATURE-----
--
Unsubscribe: kirim email kosong ke [EMAIL PROTECTED]
Arsip, FAQ, dan info milis di http://linux.or.id/milis.php
Tidak bisa posting? Baca:
http://linux.or.id/wiki/index.php?pagename=ProblemMilisDanSolusi
http://linux.or.id/wiki/index.php?pagename=TataTertibMilis
