I've undertaken my first real programming project.
It's for comparing the Provo city council candidates to encourage students to vote:
http://provocitizens.net/elections/compare.html
(it's not hooked up yet)
The candidates right now are all filling out a 17 question survey that some students and alumni came up with:
http://provocitizens.net/elections/survey.html
This part of it works. A few candidates have already filled it out and it goes into a mysql database ok.
My problem is with writing the code to display the results from the http://provocitizens.net/elections/compare.html form.
(it took me 8 hours just to get the survey.html and database input working ok so I thought I'd better ask for help since the primary is less than 2 weeks away and I was supposed to have this all ready for the Rock the Vote stuff on campus this week but have been swamped.)
Can anyone help me? Thanks,
Roger
P.S. here's my table structure in case it helps:
elections.candidates: cid (candidate id) name password district phone email photo date_posted a1 a2 a3 ( and so on. these are the answers to each of the 17 questions.) ... a17
elections.questions:
qid (question id)
summary (could be used in the compare.html but right now I just have it hard coded in that form)
question (full question for the row output from the compare.html)
(i guess it would be better to have a seperate table called answers which has the cid, qid, and answer but i found it easier to program the survey.html form with just the two above since I'm a novice.)
Roger Brown 356-1032 "All in favor of losing your rights, please do nothing."
____________________
BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________
List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
