Are there any best practices to follow when using the DESC-LIMIT clause in PHP?

When using the DESC-LIMIT clause in PHP to retrieve a limited number of rows in descending order from a database table, it is important to ensure that the query is properly constructed to avoid any errors or unexpected results. One best practice is to include an ORDER BY clause before the LIMIT clause to specify the sorting order. 

$query = "SELECT * FROM table_name ORDER BY column_name DESC LIMIT 10";
$result = mysqli_query($connection, $query);

if(mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        // Process each row here
    }
} else {
    echo "No results found";
}

Keywords

DESC-LIMIT clause PHP SQL database optimization

Related Questions