โค้ด: เลือกทั้งหมด
$sql="SELECT verygood FROM pamren WHERE depation = $d_name AND y = $y AND t = $m";
if ($result = $mysqli -> query($sql)) {
while ($row = $result -> fetch_row()) {
printf ($row['verygood']);
}
[img][attachment=0]Programming - PHP-1.png[/attachment][attachment=0]Programming - PHP-1.png[/attachment][/img]
$query = "SELECT * FROM pamren" or die("Error:" . mysqli_error()); .
$result = mysqli_query($con, $query);
echo "<table id='example' class='display' cellspacing='0' border='1'>";
echo "<thead>";
echo "<tr>";
echo "<tr align='center' bgcolor='#CCCCCC'><td>สำนัก/กอง</td><td>ดีมาก</td><td>ดี</td><td>ปานกลาง</td><td>น้อย</td><td>น้อยมาก</td><td>เดือนที่</td><td>ปีงบประมาณ</td></tr>";
echo "</tr>";
echo "</thead>";
while($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo "<td>"."<center>" .$row["depation"] ."</center>"."</td> ";
echo "<td>" .$row["verygood"] . " </td> ";
echo "<td>" .$row["good"] . "</td> ";
echo "<td>" .$row["fair"] . "</td> ";
echo "<td>" .$row["poor"] . "</td> ";
echo "<td>" .$row["verypoor"] . "</td> ";
echo "<td>" .$mm . "</td> ";
echo "<td>" .$yy . "</td> ";
echo "</tr>";
}
echo "</table>";