<?php
   // see if we have selected a game.
   // example URL: http://www.thegamezone.co.nr/platform/games.php?game=12
   // Now we are playing platform game no. 12
if(isset($_GET['game'])){   
   // Connect to and select your database
   
   $game = mysql_real_escape_string($_GET['game']));
      // Now $game is safe to use in a database query.
      
      // Put code for loading the game here.
      // ***
      
      // See if we just clicked rate
   if(isset($_POST['gamerating'])){
         
      // we did just click rate! so do the actual rating.
      $rating = $_POST['RatedValue'];
      $result = mysql_query("SELECT * FROM game_ratings WHERE game_id = '$game'");
      
      //Check if the current game has been rated before
      if(mysql_num_rows($result)>0){
         while($row = mysql_fetch_array($result)){   
            $num_ratings = $row['number_of_ratings'];
            $current_rating = $row['rating'];
            
            // do the math
            $to_insert = $current_rating * $num_ratings;
            $to_insert = $to_insert + $rating;
            $num_ratings = $num_ratings + 1;
            $to_insert = $to_insert / $num_ratings;
            $to_insert = round($to_insert,2);
            
            // update database
               mysql_query("UPDATE game_ratings SET number_of_ratings = '$num_ratings', rating = $to_insert WHERE game_id = '$game'");
            }
      }else{
         // this game has not been rated, create a row for it.
         mysql_query("INSERT INTO game_ratings (number_of_ratings, rating, game_id VALUES('1','$rating','$game')");
      }
   }else{
      
      // otherwise show the rate form
      // Here goes a simple rate form.
      echo "<form action=\"\" method=\"post\">";
      echo "<select name=\"RatedValue\">";
      for($i=0;$i<11;$i=$i+1){
   
         // Create a dropdownlist with values 1-10
         echo "<option value=\"".$i."\">".$i."</option>";
      }   
      echo "</select>";
      echo "<input type=\"submit\" value=\"Rate\" name=\"gamerating\" />";
      echo "</form>":   
   }
   
   // close the database connection here.   

}else{
   // This is what will be seen of no game is selected
}
?>

<?php
$db = array(
'hostname' => 'localhost',
'username' => 'your_username',
'password' => 'your_password',
'database' => 'the_database',
);
?>

<?php
function dbcon() {
if(!include_once('dbinfo.php')) {
die('Error include file...');
}
if (!$con = mysql_connect($db['hostname'],$db['username'],$db['password'])) {
die('Error connecting...');
}
if (!mysql_select_db($db['database'],$con)) {
die('Error selecting...');
}
return $con;
}
?>

   
include_once 'includes/dbcon.php';
$link = dbcon();

$result = mysql_query("SELECT * FROM paka_example");

mysql_close($link);