Advertisement
GWibisono

error di mysql itu perlu

May 27th, 2012
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. include '../Config/konek.php';
  2. $q=mysql_query('select * from plan');
  3. $i=1;
  4. while ($r=mysql_fetch_array($q)){
  5. $sql="INSERT INTO `plan2` (
  6. `KODE_PLAN` ,
  7. `ANGKATAN` ,
  8. `TGL_MULAI` ,
  9. `TGL_AKHIR` ,
  10. `ANGGARAN` ,
  11. `PST_A` ,
  12. `TGL_AWAL_REAL` ,
  13. `TGL_AKHIR_REAL` ,
  14. `ANGGARAN_REAL` ,
  15. `PST_REAL` ,
  16. `KODE_M` ,
  17. `TEKHNIK` ,
  18. `STREAM` ,
  19. `NAMA_M_TRAINING` ,
  20. `PL` ,
  21. `JP` ,
  22. `KODE_INST` ,
  23. `NAMA_INST` ,
  24. `KODE_UBIS` ,
  25. `NAMA_HR` ,
  26. `KODE_HR` ,
  27. `KODE_LC` ,
  28. `NAMA_LC` ,
  29. `KOTA` ,
  30. `Terlaksana` ,
  31. `Komen`
  32. )
  33. VALUES (
  34. '', $r[KODE_PLAN] , $r[angkatan] , $r[TGL_MULAI] , NULL , NULL , NULL , NULL , NULL , NULL , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
  35. )
  36. ";
  37. $h= mysql_query($sql) or die(mysql_error()."<p>$sql");
  38.  
  39.    $i++;
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement