title: PHP/MYSQL only allowing one vote per member?
body: <p>ive been giving the task at work of setting up an awards voting system, I dont know too much about php and mysql. But i know more about this than anyone else here, and my boss in on holiday. But I've been reusing the code, that had previously been left on our system and adapting it for this year.</p>
  
  <p>Basically the voting system works fine, and I've set up new tables in mysql to capture the data. I've found one fairly large flaw in the existing code though and am not sure how to modify it. Basically the code allows people to vote as many times as they want at the moment. I want to restrict it to only 1 vote per member, to keep things fair.</p>
  
  <p>So at the moment, members log in with a membership number, then vote. The votes are stored in the mysql tables, and i can then add up the votes by querying the data.</p>
  
  <p>I was hoping someone can help me in adding a line or two of code, that will simply check to see if a member has already voted. When a member votes, their member no. is stored in the sql tables along with their votes selections. So maybe the best way is to see if a memeberid already exists in the table, and if it does, tell the user that they have already voted - or words to that effect.</p>
  
  <pre><code>&lt;?php
  //Insert into volunteer awards
  $coach=mysql_real_escape_string($_SESSION['coach']);
  $official=mysql_real_escape_string($_SESSION['official']);
  $young_volunteer=mysql_real_escape_string($_SESSION['young_volunteer']);
  $volunteer=mysql_real_escape_string($_SESSION['volunteer']);
  
  $memberid=$_SESSION['MM_Username'];
  $association=$_SESSION['MM_Association'];
  $region=$_SESSION['Region'];
  
  
  $sql_query = mysql_query("INSERT INTO awards_2009_votes (`id`, `member_id`, `region`, `coach`, `official`, `volunteer`, `young_volunteer`) VALUES ('', '$memberid', '$region', '$coach', '$official', '$volunteer', '$young_volunteer')") or die (mysql_error());
  ?&gt;
  </code></pre>
  
  <p>Thanks</p>