niamhybo

I have a mac... need to do my coursework asap! and i dont even know where to start, i doenloaded text wrangler, and thats what i have done so far. COM302 Web Database Systems Supplementary Coursework Summer 2012 COM302 FM ? Song of the week! COM302 FM is an online radio station that provides its listeners with an opportunity to influence their playlist with a ?Song Of The Week? vote. Your task is to provide a PHP-based application that manages the ?Song Of The Week? competition. 
 STAGE 1: Selection of the competing songs The application chooses 5 songs at random from the existing ?tracks? table and stores their IDs in a new ?songOfTheWeek? table. 
 The application displays track, album and artist information for the 5 selected songs. STAGE 2: The vote The application presents a form, which enables a user to rank the five competing songs in order of preference.
 Songs are awarded 10 points for a 1st preference selection, 8 for 2nd preference, 6 for 3rd preference etc., down to 2 points for a 5th preference choice. The current score for each competing song should be held in the ?songOfTheWeek? table.
 After each user has voted, the current vote standings and the number of users who have voted so far should be displayed STAGE 3: Final results Once 10 users have voted, the details of the winning song are displayed. The interface should not accept any further votes HELP!!!