I thought that maybe I would clarify my post, I seem to get a lot views, but no replys yet.
If I use the following code, I get no error:
$result = mysqli_query($link, 'SELECT id, name, rank, opened, active');
And "opened" in MYSQL is a DATE column. The date that is displayed is YYYY-MM-DD. I was hoping to get the date to display as follows... d-m-Y.
When I use the following code, I get an error:
$result = mysqli_query($link, 'SELECT id, name, rank, DATE_FORMAT(opened, '%d-%m-%Y'), active');
I'm not sure if I'm using DATE_FORMAT incorectly or if there is another method? Thanks again for reading my post and any help/suggestions would be greatly appreciated. --Ben