Reputation: 0 Apprentice
- Active Posts:
- 22 (0.06 per day)
- 05-March 13
- Profile Views:
- Last Active:
- Mar 11 2014 03:31 PM
- Dream Kudos:
Posts I've Made
Posted 11 Mar 2014Haha woops, I was just putting in random dates to test it. So that now works when I put a correct date in, Thank you.
Posted 11 Mar 2014Okay so I have tried this code below;
<?php $date = "Tuesday 10 September 2000"; $newdate = date('d/m/Y', strtotime($date)); echo $newdate; ?>
but the output is 12/09/2000 and not 10/09/2000?
Does anyone know why this is? (it seems that it's added the day of week to the date of month but I don't know why?)
Posted 5 Mar 2014I think it may have been to do with the hierarchy of the XML.
if I add an extra XML tag to wrap the match inside it works..
Posted 5 Mar 2014Sorry the problem was that it wasn't outputting any information at all.
Posted 20 Feb 2014I have managed to get it working another way..
I have deleted the trigger and deleted the column goalsDifference as well, so its much better.
The SQL code is..
SELECT premTeamName, points, goalsFor, goalsAgainst, goalsFor - goalsAgainst AS difference FROM prem_team ORDER BY points DESC, difference DESC, goalsFor DESC
Thank you for help.
- Member Title:
- New D.I.C Head
- Age Unknown
- Birthday Unknown
UnknownCodester hasn't added any friends yet.