cliftonbazaar Posted January 2, 2010 Share Posted January 2, 2010 $matches = mysql_fetch_array(mysql_query("SELECT * FROM matches WHERE homeTeamID='".$_SESSION["teamID"]."'")); $matchID=$matches['matchID']; This code returns the FIRST record where homeTeamID='".$_SESSION["teamID"].", what I want is the LAST record of when this occurs. Link to comment https://forums.phpfreaks.com/topic/186920-getting-the-last-occurance-of-data/ Share on other sites More sharing options...
Mchl Posted January 2, 2010 Share Posted January 2, 2010 http://dev.mysql.com/doc/refman/5.0/en/sorting-rows.html Link to comment https://forums.phpfreaks.com/topic/186920-getting-the-last-occurance-of-data/#findComment-987068 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.