Misi bli ellix, mohon bantuannya bli.

Langsng aja, saya ingin menampilkan data perbulan sesuai dengan bulan sekarang (jika sekarang bulan september maka data yang akan di tampilkan hanya data bulan september saja sedangkan data bulan yang lain tidak ditampilkan).

berikut script saya.

<link rel="stylesheet" type="text/css" media="all" href="css/style.css" />
<?php
include"koneksidb.php"
?>
<table width="700" border="1" id="event-listing">
  <tr>
    <td class="head-event-title">
    <strong>Event Date</strong>
    </td>
    <td style=" width:300px;" class="head-event-content">
    <strong>Event</strong>
    </td>
    <td style=" width:90px;" class="head-event-location">
    <strong>Location</strong>
    </td>
    <td style=" width:138px;" class="head-event-sidebar">
    <strong>Output</strong>
    </td>
    
  </tr>
  
  <tr>
  <?php
  $sql = "SELECT * FROM tbl_jadwal ORDER BY tanggal_1";
  $qry = mysql_query($sql, $koneksi) or die ("SQL Error".mysql_error());
  while ($data=mysql_fetch_array($qry)) {
  //$no++;
  ?>
    <td class="event-date" style="height: 75px; width:90px;">
	<?php echo $data['tanggal_1']; ?><br />
  	s/d<br />
	<?php echo $data['tanggal_2']; ?>
    </td>
    <td class="event-content" style="height: 75px; width:300px;">
<b>    
    <!--?php echo $data['kode_jenis_jadwal']; ?!-->
    <?php
	
		$x=$data['kode_jenis_jadwal']; 
		
		if($x=='1'){
		echo 'Tes1';
		}elseif($x=='2'){
		echo 'Tes2';
		}elseif($x=='3'){
		echo 'Tes3';
		}elseif($x=='4'){
		echo 'Tes4';
		}else{
		echo 'Tes5';
		}
		
	?>
</b>
<p><?php echo $data['isi_jadwal']; ?></p>
</td>
    <td class="event-location" style="height: 75px; width:90px;">
    <?php echo $data['tempat_ditetapkan']; ?>
    </td>
    <td class="event-sidebar" style=" width:138px;">
    <a class="btn-blue" href="../jadwal/upload/<?php echo $data['nama_file']; ?>">Download Output</a>
    </td>
    <?php
  	}
 	?>
  </tr>
</table>
	

|

sebelum dan sesudahnya makasih bli...

$sql = "SELECT * FROM tbl_jadwal ORDER BY tanggal_1";

<link rel="stylesheet" type="text/css" media="all" href="css/style.css" />
<table width="700" border="1" id="event-listing">
  <tr>
    <td class="head-event-title">
    <strong>Event Date</strong>
    </td>
    <td style=" width:350px;" class="head-event-content">
    <strong>Event</strong>
    </td>
    <td style=" width:150px;" class="head-event-location">
    <strong>Location</strong>
    </td>
    <td style=" width:216px;" class="head-event-sidebar">
    <strong>Output</strong>
    </td>
    
  </tr>
  
  <tr>
    </tr>
</table>

$sql = "SELECT * FROM tbl_jadwal where month(tanggal_1)='".date('m')."' ORDER BY tanggal_1";

$sql = "SELECT * FROM tbl_jadwal ORDER BY tanggal_1";