What is the significance of using "DESC" in the SQL query for sorting data in PHP?

When using "DESC" in an SQL query in PHP, it specifies that the data should be sorted in descending order. This is useful when you want to retrieve data in reverse chronological order or from highest to lowest values. By including "DESC" in your query, you can easily control the order in which the data is displayed or processed. 

// Example SQL query in PHP using DESC for sorting data
$query = "SELECT * FROM table_name ORDER BY column_name DESC";
$result = mysqli_query($connection, $query);

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

Keywords

PHP SQL query DESC sorting data significance

Related Questions