I'm using a php & mssql. On my mssql i have a table name score. it has 3 fields fieldScore, fieldName, fieldDateAdded where data are records from january to december 2008. On the otherhard, In my php code i created also a table with 4 columns ColScore, ColName, ColDateAdded, ColPrevScore. My concern is on the ColPrevScore, how do i code in php to get the data in fieldScore to display in ColPrevScore assuming that im now viewing data for the month of May and i want to display in ColPrevScore the last month(April). However, if no score found for the month of April, it will loop back on the next previous months until score is found.
