time()) ? 1 : 0; $qvoted = "SELECT * FROM TU_Votes WHERE "; $qvoted.= "VoteID = " . $row['ID'] . " AND "; $qvoted.= "UserID = " . uid_from_sid($_COOKIE["AURSID"]); $hasvoted = mysql_num_rows(db_query($qvoted, $dbh)); # Can this person vote? # $canvote = 1; // we assume they can $errorvote = ""; // error message to give if ($isrunning == 0) { $canvote = 0; $errorvote = "Voting is closed for this proposal."; } else if ($row['User'] == username_from_sid($_COOKIE["AURSID"])) { $canvote = 0; $errorvote = "You cannot vote in an proposal regarding you."; } else if ($hasvoted != 0) { $canvote = 0; $errorvote = "You've already voted in this proposal."; } # have to put this here so results are correct immediately after voting if ($canvote == 1) { if (isset($_POST['doVote'])) { if (isset($_POST['voteYes'])) { $myvote = "Yes"; } else if (isset($_POST['voteNo'])) { $myvote = "No"; } else if (isset($_POST['voteAbstain'])) { $myvote = "Abstain"; } $qvote = "UPDATE TU_VoteInfo SET " . $myvote . " = " . ($row[$myvote] + 1) . " WHERE ID = " . $row['ID']; db_query($qvote, $dbh); $qvote = "INSERT INTO TU_Votes (VoteID, UserID) VALUES (" . $row['ID'] . ", " . uid_from_sid($_COOKIE["AURSID"]) . ")"; db_query($qvote, $dbh); # Can't vote anymore # $canvote = 0; $errorvote = "You've already voted for this proposal."; # Update if they voted $hasvoted = mysql_num_rows(db_query($qvoted, $dbh)); $results = db_query($q, $dbh); $row = mysql_fetch_assoc($results); } } echo "
because it still maintains word wrapping
print str_replace("\n", "
\n", $row['Agenda']);
print "
\n";
print "
\n";
print "\n";
print "\n";
print "\n";
print "\n";
print " \n";
print "\n";
print "\n";
print " ";
print "Yes";
print " \n";
print " ";
print "No";
print " \n";
print " ";
print "Abstain";
print " \n";
print " ";
print "Total";
print " \n";
print " ";
print "Voted?";
print " \n";
print " \n";
$c = "data1";
print "\n";
print " ";
print $row['Yes'];
print " \n";
print " ";
print $row['No'];
print " \n";
print " ";
print $row['Abstain'];
print " \n";
print " ";
print ($row['Yes'] + $row['No'] + $row['Abstain']);
print " \n";
print " ";
if ($hasvoted == 0) {
print "No";
} else {
print "Yes";
}
print " \n";
print " \n";
print "
\n";
print "
\n";
echo " | \n"; print " $application\n"; print " | \n"; print "||||||||||||||
\n";
print "
| ||||||||||||||
| \n"; if ($off != 0) { $back = (($off - $limit) <= 0) ? 0 : $off - $limit; print "Back"; } print " | \n"; print "\n"; if (($off + $limit) < mysql_num_rows($nextresult)) { $forw = $off + $limit; print "Next"; } print " | \n"; print "