How can errors in PHP scripts be effectively handled and displayed using mysql_error()?

Errors in PHP scripts can be effectively handled and displayed using the mysql_error() function by capturing the error message returned by MySQL and displaying it to the user. This can help in troubleshooting issues with database queries and connections.

// Execute the query
$result = mysql_query($query);

// Check for errors
if (!$result) {
    die('Error: ' . mysql_error());
}