What is the significance of the ASC keyword at the end of an ORDER BY clause in a PHP MySQL query?

The ASC keyword in an ORDER BY clause specifies that the results should be sorted in ascending order based on the specified column. If the ASC keyword is not used, the default sorting order is ascending. It is important to include the ASC keyword if you want to explicitly specify the sorting order in your MySQL query. Example PHP code snippet: 

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

// Fetch and display results
while ($row = mysqli_fetch_assoc($result)) {
    echo $row['column_name'] . "<br>";
}

Keywords

PHP MySQL ASC ORDER BY query

Related Questions