 |
|
สอบถามหน่อยช่วย!! ข้อมูลจาก Database ที่ดึงขึ้นมาแสดงด้วย Swap !
ตัวอย่าง
Code (PHP)
SELECT * FROM members ORDER BY date_of_birth DESC;
----------------
php sql
Code (PHP)
<?php
$con= mysqli_connect("localhost","tttt","1122","tttt") or die("Error: " . mysqli_error($con));
mysqli_query($con, "SET NAMES 'utf8' ");
$query = "SELECT SUM(NUM) AS NUM, DATE_FORMAT(DATE, '%d-%m-20%y') AS DATE FROM daily GROUP BY DATE_FORMAT (DATE, '%d%-%m%-20%y%')";
$result = mysqli_query( $con, $query);
$resultchart = mysqli_query( $con, $query);
//for chart
$DATE = array();
$NUM = array();
list($b,$a) = array($a,$b);
while($rs = mysqli_fetch_array($resultchart)){
$DATE[] = "\"".$rs['DATE']."\"";
$NUM[] = "\"".$rs['NUM']."\"";
}
$DATE = implode(",", $DATE);
$NUM = implode(",", $NUM);
?>
$query = "SELECT SUM(NUM) AS NUM, DATE_FORMAT(DATE, '%d-%m-20%y') AS DATE FROM daily GROUP BY DATE_FORMAT (DATE, '%d%-%m%-20%y%')";
แก้ไข ช่วยหน่อย
$query = "SELECT SUM(NUM) AS NUM, DATE_FORMAT(DATE, '%d-%m-20%y') AS DATE FROM daily GROUP BY DATE_FORMAT (DATE, '%d%-%m%-20%y%') ORDER BY NUM DATE DESC ";
ขอบคุร ตอบมาด้วยระ
จาก https://www.guru99.com/order-by-desc-and-asc.html
Tag : PHP, MySQL, CakePHP, FuelPHP
|
|
|
 |
 |
 |
 |
| Date :
2018-02-09 15:48:30 |
By :
kittisak09 |
View :
702 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
|
 |
