score using php/mysql

[Snubby]

Hey guys. I want to have registered users vote on the stuff on my website. But I don't know how to do that. I would want each user to only be able to vote once on each submission, so I would need to keep track of which users voted on what. I know how to do the average though, just have a score and number of votes record for each thing. but its the keeping track of who has voted that is stumping me.

Thanks.

[Shadow00881]

Just create a database, and when a user votes, have the database has a record of it the use has ever voted before. If they have, alert, or something:

<?php
//DB connect code here
function checkVote() { 
$query = mysql_query("SELECT FROM table WHERE username='$user' AND game='$game'");
//Count the rows, if count is greater than 1, echo an error, else, insert into database table
$numrows = mysql_num_rows($query);
if ($numrows > 1) { 
 echo 'You've already voted on this game!';
} else {
 $dbinsert = mysql_query("INSERT INTO table(`username`, `game`) VALUES('$username', '$game')");
 if (!dbinsert) {
  echo '<script>alert("FATAL ERROR!");</script>
 } else {
 echo 'Thank you! You have been inserted into the database!';
}
}
?>

That should work, Note! There are some empty variables that need to be defined!

For the login, search Google for php/mysql login.

[Snubby]

I don't think that's even close to what I need. I need to keep track of who has voted on what. Your query just checked if the username was something, and if the game was some game. It didn't really do anything at all.

[Shadow00881]

it checks to see if the user has already voted on the game

[Shadow00881]

BTW, sorry, i forgot a closing bracket at the end

[Snubby]

so I would need a table with every member and every game? like i could stick every thing i want to rate as a new field into my members table, but then it could end up having hundreds of fields. and vice versa, i could have each user as a feild in each content table, but then im still looking at hundreds of fields. is that the only way of doing it?

[Afro-Ninja]

At 1/18/08 12:08 AM, Snubby wrote: so I would need a table with every member and every game? like i could stick every thing i want to rate as a new field into my members table, but then it could end up having hundreds of fields. and vice versa, i could have each user as a feild in each content table, but then im still looking at hundreds of fields. is that the only way of doing it?

you have a users table, and a games table, I'm assuming. So you make a third table- user_game_votes

whenever a user votes on something, add an entry to the user_game_vote table. It will basically consist of four values- id (unique auto_increment), user id, game id, and vote(whatever they rated the game).

before you let someone vote on the game, select count from user_game_vote where userid = their id and game id = the current game's id. If a row is returned then they have already voted, so they can't. Otherwise, add the new row

to calculate score for a game, select all rows from the user_game_vote table where game id= the current game. Add them up an divide by the total rows for your average, and there you go

that's the basic idea

[Snubby]

Thanks man that's perfect.