GepComty

Untitled

Feb 7th, 2014
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. tabel rw(id_rw,nama_rw)
  2. ax1 RW1
  3. ax2 RW2
  4.  
  5. tabel rt(id_rt,id_rw,nama_rt)
  6. az1 ax1 RT1
  7. az2 ax2 RT4
  8. az3 ax1 RT5
  9.  
  10. <?php
  11. mysql_connect("localhost","root","");
  12. mysql_select_db("coba");
  13. $rw =mysql_query("select * from rw");
  14. $resultx = array();
  15. while ($baca_data_rw = mysql_fetch_array($rw)) {
  16. $rt = mysql_query("select * from rt where id_rw = '$baca_data_rw[id_rw]' ")or die(mysql_error());
  17. $jump = mysql_num_rows($rt);
  18. echo "<h2>nama : $baca_data_rw[nama_rw] | id : $baca_data_rw[id_rw] | jumlah rt: $jump</h2>";
  19. $r = 1;
  20. while ($baca_data_rt = mysql_fetch_array($rt)) {
  21. echo $baca_data_rt['nama_rt']." | ".$baca_data_rt['id_rw']."</br>";
  22. $resultx[]=$baca_data_rt['id_rw'];
  23. }
  24. echo count($resultx);
  25. echo "<pre>";
  26. print_r($resultx);
  27. echo"</pre>";
  28.  
  29. }
  30. ?>
  31. output array :
  32. pertama
  33. Array
  34. (
  35. [0] => ax1
  36. [1] => ax1
  37. )
  38. kedua
  39. Array
  40. (
  41. [0] => ax1
  42. [1] => ax1
  43. [2] => ax2
  44. )
  45.  
  46. Harusnya yg kedua cuma
  47. Array
  48. (
  49. [0] => ax2
  50. )
Advertisement
Add Comment
Please, Sign In to add comment