mhellman
2-27-04, 11:36 PM
Ok here is the scenario:
I have a table in my database that records peoples ratings. Users can vote between 1 and 10. When the user submits his/her vote the database adds 1 to whatever number they chose, adds the amount of the number to a total, and adds 1 to the amount of people that have voted. This is so that I can display a bar graph with the results.
Here is the problem:
After a certain amount of votes (about 250 or so) the amount voted and the total resets. I am almost positive that it is not because I set the properties of these columns incorrectly. I made them an int of about the length of 10.
Please help me, I am stumped. Thank you for your time.
Michael
I have a table in my database that records peoples ratings. Users can vote between 1 and 10. When the user submits his/her vote the database adds 1 to whatever number they chose, adds the amount of the number to a total, and adds 1 to the amount of people that have voted. This is so that I can display a bar graph with the results.
Here is the problem:
After a certain amount of votes (about 250 or so) the amount voted and the total resets. I am almost positive that it is not because I set the properties of these columns incorrectly. I made them an int of about the length of 10.
Please help me, I am stumped. Thank you for your time.
Michael