Adding Polls to website (php and mysql - and a bit of javascript)

Hi, On my educational site I'd like teachers to be able to quickly and easily create polls that the students can do by means of selecting an option via a radio button, with the results displaying on submit. I've created the form where the poll can be created ( [login to view URL]) which is processed on [login to view URL], with data from this stored in the tbl_poll_titles and tbl_polls tables (sql dumps attached) TASK 1 - involves making some edits to these pages. Details below. TASK 2 - involves involves making changes to add functionality to the page where the students can view and complete the poll ( [login to view URL]) Cheers, Dave ## Deliverables TASK 1 details: I need some functionality added to the [login to view URL] page so that options can be added to the poll. The page has optional items inside the tables of class greenoutline and mandatory items in the tables of css class redoutline. Basically for a poll it is mandatory to: - Have a question (eg: My favourite colour is....) - Have two options (eg: i - Blue ii - Yellow. Each option can be accompanied by a picture, but this is not mandatory. Note: The non-mandatory field poll_title_image is an image that can accompany the poll. The functionality for this is already completed and it is posted in the poll_title_images folder. Any poll_option_pictures should be uploaded to the folder poll_images. There is a button beneath the last table with the [login to view URL] and the text "Add another optioin". TASK 1.1 - When this is pressed, another textbox should appear to add another option to the poll and a file browse icon should appear to upload an image for that option. TASK 1.2 - Also, when this button is pressed, the [login to view URL] and the "Remove option" text should become visible. When pressed, these should remove the latest fields displayed. NOTE: To help with these tasks I've included the file [login to view URL] (and associated tables and js files) which has very similar functionality. Look at these and use relevant code to help you. TASK 1.3 - The poll_question, poll_option1 and poll_option2 fields need to be made mandatory (probably using the js file new_poll_formUtil ) Because these involve tiny_mce, this is a little bit tricky, but I see there are solutions available, such as <[login to view URL]> When the "Add another option" button is pressed, additional options should be mandatory as well. Ie: The form can't be submitted with a blank option, although for each option, uploading a picture should NOT be mandatory. TASK 1.4 - Processing. As you can see, poll_name, poll_title_image and poll_password are all inserted into the tbl_poll_titles table. All poll options (poll_option1, poll_option2 and any others added) need to be inserted into the poll_option field of the tbl_polls table. All poll picture options (poll_option_picture1, poll_option_picture2 and any others added) need to be inserted into the poll_option_picture field in the tbl_polls table. Note: As mentioned above, these pictures should be uploaded to the poll_images folder, and the file name should be changed as it is done with the poll_title_image so that the image is renamed to [IMAGENAME][DATETIMESTAMP][IMAGE_EXTENSION]. I think that covers the poll creation. Task 2 involves viewing and completing the poll. TASK 2 involves the [login to view URL] and [login to view URL] files. Students can search for a poll using the poll_id and poll_password fields. To get an idea of this, go to <[login to view URL]> and use poll_id 9 and password secret You'll see that on the display page the poll_title and poll_question are displayed 4 times. TASK 2.1 -> This needs to be rectified so the title and question are only displayed once. The poll_title_image, it should be displayed once too, with height / width limited to 300pix max. TASK 2.2 -> Bear in mind that polls do not need to be protected by a password. If a student searches for a poll_id that does not exist, or they get a password wrong where a poll does have a password, they should be given a message saying "There is no poll matching your search, please try again". TASK 2.3 -> Next to or under the row_counter for each row of the table, there needs to be a radio button, so students can choose an option to vote in the poll. When they press the "Vote Now" button at the bottom of the poll, the results should appear in the third column of the table (ie: Where you see the text RESULTS TO APPEAR HERE. Results should be in text format to 2 decimal places where applicable, and also in a visual format. (ie: horizontal bar. Would be good if the bar was a different colour for each option added, but this is not essential. I assume this will involve the tbl_poll_votes table. This may need to be tweaked a bit. Anyway, that covers it. I think I've explained it pretty clearly, but please ask if you have any questions. Cheers, Dave