Simple Rating Script

Hi,

What I am wanting is a simple rate up or rate down script that only allows users to vote once.

I have created the page (see picture and script) which has an up and a down image and also counts how many votes there are.

The Up/Down links to this page however it doesn't update or decrease:

<?
include 'admin/config.php';

$FeedItemID = $_GET['feed'];
$voted = $_GET['voted'];

$sql = 'UPDATE FeedbackScore SET Score = +$voted WHERE FeedItemID = '$FeedItemID'';
 
?>

What i also want to include in this some code so that users can only vote once. I was thinking i could achieve this by having this table:

FeedbackScoreUser
  FeedUserSID
  FeedItemID
  StudentID

and adding to this table when the rating is updated. The student ID is store in the session so to get to it:

$username = $_SESSION['username'];

Hope that all makes sense, i'm extremely tired!

/// add / view votes
 
<?php 
 
 
include 'admin/config.php';
 
 
$FeedItemID = $_GET['feed'];
 
 
echo '<div><p>';
echo '<a href="updateScore.php?voted=1&feed='.$FeedItemID.'"><img src="images/vote_yes.gif" alt="Vote Up" width="13" height="13" /></a>';
echo '   ';
echo '<a href="updateScore.php?voted=-1&feed='.$FeedItemID.'"><img src="images/vote_no.gif" alt="Vite Down" width="13" height="13" /></a>';
echo '</p>';
 
 
 
function get_row($query) {
	   $result = mysql_query($query);
	   $row = mysql_fetch_array($result);
	    return($row);
	}
 
    $score = get_row("SELECT Score
FROM FeedbackScore
WHERE FeedItemID = '$FeedItemID'");
 
 
 echo '<div id="bg">| <b>'.$score['Score'].'</b></div>'; ?>

Select allOpen in new window

rating.gif