how do i do it? lets say i’m making a poll and this is what i have:
// table structure
// name, question, numans, ans1, ans2, ans3, ans4, ans5, res1, res2, res3, res4, res5
ans1-5 are possible selections (string);
res1-5 are number of votes (int);
now, say i already have a row pre-selected and i want to select one of ans1-5 based on the highest numerical value from res1-5… for instance: res2 has 5 votes, the greatest out of any of the others. what i need to do is select only ans2.
possibilities?