Hello all, I'm very new to using PHP and just need a little help with formating the date via MYSQL. Here is the code that I am getting an error on...

$result = mysqli_query($link, 'SELECT id, name, rank, DATE_FORMAT(opened, '%d-%m-%Y'), active');

Thank you for taking time to read my post and any suggestions would be greatly appreciated. --Ben