Jadwal Pelatihan
 |
Program |
Kelompok Program |
Mulai |
Selesai |
$qprog = mysql_query("SELECT * FROM program order by tanggal desc");
while($dprog=mysql_fetch_array($qprog)){
$dpelat=mysql_fetch_array(mysql_query("select * from pelatihan where idp='".$dprog['idp']."'"));
$dpelatg=mysql_fetch_array(mysql_query("select * from pelatihangrup where idpg='".$dpelat['idpg']."'"));
$tgl=substr($dprog['tanggal'],8,2)."-".substr($dprog['tanggal'],5,2)."-".substr($dprog['tanggal'],0,4);
$tgls=substr($dprog['selesai'],8,2)."-".substr($dprog['selesai'],5,2)."-".substr($dprog['selesai'],0,4);
echo "
 |
".strtoupper($dpelat['judul'])." |
".$dpelatg['judul']." |
".$tgl." |
".$tgls." |
";
}
?>
|
|