SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | include '/home/.../public_html/member/koneksi.php'; | |
| 3 | - | $q=mysql_query("select distinct dari from pesan where untuk='55555' group by waktu desc");
|
| 3 | + | |
| 4 | - | while($r=mysql_fetch_array($q)){
|
| 4 | + | $i=0; |
| 5 | - | $dari=$r['dari']; |
| 5 | + | $sql="select distinct dari |
| 6 | - | $query=mysql_query("select*from pesan where dari='$dari' and untuk='55555' order by waktu desc");
|
| 6 | + | from pesan |
| 7 | - | while($atsv=mysql_fetch_array($query)){
|
| 7 | + | where |
| 8 | - | echo"Dari:$atsv[dari]"; |
| 8 | + | untuk='55555' |
| 9 | - | $id=$atsv['id']; |
| 9 | + | group by waktu desc"; |
| 10 | - | $atsq=mysql_query("select*from pesan where id='$id' order by waktu desc limit 1");
|
| 10 | + | /* |
| 11 | - | while($atsx=mysql_fetch_array($atsq)){
|
| 11 | + | piye... enak khan ngelihat begini |
| 12 | - | echo"<br/>$atsx[pesan]<p>"; |
| 12 | + | */ |
| 13 | - | } |
| 13 | + | $q=mysql_query($sql); |
| 14 | while($r=mysql_fetch_array($q)) | |
| 15 | {
| |
| 16 | $dari=$r['dari']; | |
| 17 | $sql="select * | |
| 18 | from pesan | |
| 19 | where | |
| 20 | dari='$dari' | |
| 21 | and untuk='55555' | |
| 22 | order by waktu desc"; | |
| 23 | /* | |
| 24 | hindari pake * | |
| 25 | hindari berarti berusaha untuk tidak MEMAKAInya | |
| 26 | */ | |
| 27 | $query=mysql_query($sql); | |
| 28 | while($atsv=mysql_fetch_array($query)) | |
| 29 | {
| |
| 30 | $i++; | |
| 31 | echo"<br>$i Dari:$atsv[dari]"; | |
| 32 | $id=$atsv['id']; | |
| 33 | $sql="select * | |
| 34 | from pesan | |
| 35 | where id='$id' | |
| 36 | order by waktu desc | |
| 37 | limit 1"; | |
| 38 | /* | |
| 39 | hindari pake * | |
| 40 | hindari berarti berusaha untuk tidak MEMAKAInya | |
| 41 | dan kamu pake limit 1 disini | |
| 42 | */ | |
| 43 | $atsq=mysql_query($sql); | |
| 44 | while($atsx=mysql_fetch_array($atsq)) | |
| 45 | {
| |
| 46 | echo"<br/>$atsx[pesan]<p>"; | |
| 47 | } | |
| 48 | } | |
| 49 | } | |
| 50 | /* | |
| 51 | Ada kecurigaan.. jangan2 waktunya itu... | |
| 52 | ||
| 53 | tanggal Indonesia bukan tanggal | |
| 54 | tahun-bulan-tanggal jam:menit:detik | |
| 55 | */ | |
| 56 | ?> |