I have a Query that I would like to modify the Date/Time format in the presentation, however when I use date_format, my query goes pearshaped.
working:-
$result = mysql_query("SELECT opposition, id, venue, team, level, points_for, points_against, triescons, pens, drop_g, result, report, pictures from fixtures where team =1");
This is then placed into a table for viewing.
However, when I try:-
$result = mysql_query("SELECT date_format(date'%b %D, %Y -- @ %T hrs'), opposition, id, venue, team, level, points_for, points_against, triescons, pens, drop_g, result, report, pictures from fixtures where team =1");
It doesn't work. I think it is an issue with the Brackets within Brackets, but just guessing here. The query works fine as a cmd line but not with PHP.
Sorry if this is below you guys, but I'm stuck