soedirman15@gmail.com atau WA 085740291996

Rabu, 18 Desember 2013

Query Menampilkan data ke samping dengan PHP

<p><strong>PLAN TPS</strong></p>
 <br> <table height="91" border="0">
   <tr><td>
<table width="100%" border="0">
  <tr>  
    <td bgcolor='#99FF00'>NO</td>
    </tr>
    <tr>
    <td  bgcolor='#99FF00'>DATE</td>
    </tr>
    <tr>
    <td>TRACKING</td>
    </tr>
     <tr>
    <td>MODEL </td>
    </tr>
    <tr>
    <td>SHIFT</td>
    </tr>
    <tr>
    <td>QTY</td>
    </tr>
</table></td>
<?php
include "excel_reader2.php";
    include "koneksi.php";
    $no=1;
    $tampil = mysql_query("SELECT * FROM plan order by Date");
    while($r=mysql_fetch_array($tampil)){
    echo"<td><table width='100%' border='0'><tr>
        <td bgcolor='#99FF00'>$no</td></tr><tr>
        <td bgcolor='#99FF00' width='100%'>$r[3]</td></tr><tr>
        <td>$r[1]</td></tr><tr>
        <td>$r[2]</td></tr><tr>
        <td>$r[4]</td></tr><tr>
        <td>$r[5]</td></tr><tr>
       </tr></table></td>
    ";
    $no++;
    }
?>

<p><li><a href="download.php">DOWNLOAD</a></li></p>

1 komentar: