Selasa, 17 September 2013

PHP Indonesia - Facebook: [ASK} Selamat pagi agan-agan.... masih sama dengan...

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/ 
How to Get into Medical School

A tested blueprint to approach the daunting admissions process with both confidence and success! Enroll in this online course for just $29.
From our sponsors
[ASK} Selamat pagi agan-agan.... masih sama dengan...
Sep 18th 2013, 04:11, by Fefi Fajar Bsc

Fefi Fajar Bsc 4:11am Sep 18
[ASK}
Selamat pagi agan-agan....
masih sama dengan pertanyaan kemarin malam tentang menampilkan hasil data-data dari penggabungan antara tiga 3 table yaitu T.peserta, T.detail, T.pendidikan sehingga akan menjadikan table master. Tetapi masih saja error trus data yg di SELECT nya tidak tampil. Berikut query nya :

<table colspan="1" width="100%" >
<tr>
<th> No Proposal </th>
<th> Tanggal Masuk </th>
<th> Lama PKL </th>
<th> Nama Peserta </th>
<th> Nama Sekolah/Perguruan Tinggi </th>
<th> Jurusan </th>
<th> Alamat Sekolah/Perguruan Tinggi </th>
</tr>

<?php
include "../config/koneksi.php";

$query = mysql_query("select lampiran.no_prposal,detail.tanggal_masuk,detail.jumlah_pkl,peserta.nama_peserta,pendidikan.nama_sekolah,pendidikan.jurusan,pendidikan.alamat from lampiran,detail,peserta,pendidikan where peserta.antrian_peserta=pendidikan.antrian_peserta and detail.no_proposal;");

while($tampil = mysql_fetch_array($query)){
$no++;
$color =($no %2 == 0)? "bgcolor='#CCC'" : "";
?>
<tr>
<td><?php echo $tampil['no_proposal']?></td>
<td><?php echo $tampil['tanggal_masuk']?></td>
<td><?php echo $tampil['jumlah_pkl']?></td>
<td><?php echo $tampil['nama_peserta']?></td>
<td><?php echo $tampil['nama_sekolah']?></td>
<td><?php echo $tampil['jurusan']?></td>
<td><?php echo $tampil['alamat']?></td>
</tr>
<?php } ?>
</table>
?>

Anton Wahyu Pramono 4:14am Sep 18
ditest di phpmyadmin dulu,
WHERE peserta.antrian_peserta=pendidikan.antrian_peserta and detail.no_proposal; <<<< ini sepertinya aneh

Willy 4:14am Sep 18
Cb gan schema nya.dulu.. Kalo.bs, setup di sqlfiddle ;)

Reza Syaiful Hamdani 4:14am Sep 18
bukan aneh emang salah itu di bagian wherenya

Fefi Fajar Bsc 4:23am Sep 18
ok siiap Kang Anton Wahyu Pramono saya coba dulu di phpmyadmin...

scema relasi table nya Kang Willy ...???

Kang Reza Syaiful Hamdani selain pake query seperti di atas, ada yg lain ngga query nya untuk menampilkan data" nya....

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