设置While循环限制并按日期排序

Question

I am wanting find a way I can set a limit to only show 1 row from a table and also show the 1 that is by the latest created date which is a column on the row also.

<?php

$q = "SELECT * FROM nots";
$r = mysqli_query($dbc, $q);

 while ($row = mysqli_fetch_array($r)) {

     echo '<div style="background-color: red; box-sizing: border-box; padding: 20px; margin: 20px 10px; border-radius: 6px; color: #fff;">' . $row['not_name'] . '<br>'  . $row['not_content'] . '</div>';

 }

?>

Answer 1

Assuming you have an ID or date field of some sort you can use ORDER BY [yourfieldname here] DESC on that field to sort the return by the newest record first and then LIMIT 1 to grab just that record

$q = "SELECT * 
     FROM nots
     ORDER BY ID DESC
     LIMIT 1";