I am very new to perl and mysql, but I have inherited an online voting program at my college that was written by a student last year. I can telnet into the database and view the tables I need to find out election results, but I think that there must be a way I can print these tables to a file and either convert it to an Exel or Access table (or at least have the information in a .txt file). Is there anything I can add to my
select * from votes;
command to get it to print to a file?
A second question I have is regarding the query of those tables. We have a list of candidates, votes, and logins that we keep. How could I query for people who voted for person A for office A, AND person B for office B. (as opposed to everyone who voted for every office, or people who only voted for a specific office or for a specific person).
Thanks in advance.
select * from votes;
command to get it to print to a file?
A second question I have is regarding the query of those tables. We have a list of candidates, votes, and logins that we keep. How could I query for people who voted for person A for office A, AND person B for office B. (as opposed to everyone who voted for every office, or people who only voted for a specific office or for a specific person).
Thanks in advance.