CODEWITHSUNDEEP
phpmysqldatabase
Andrew
Andrew

Reputation: 218

simple php voting system doesn't update the database

<?php
session_start();
$host        =    'localhost';
$user        =    'root';
$password    =    '8******8';
$database    =    'tg*****ba';

$conn = mysql_connect($host,$user,$password) or 
  die('Server Information is not Correct'); 

//Establish Connection with Server
mysql_select_db($database,$conn) or die('Database Information is not correct');
$InGameName    =    mysql_real_escape_string($_POST['InGameName']);
$LastVoteTime;

//===When I will Set the Button to 1 or Press Button to register
if(isset($_POST['btnVote'])) 
{
  if(md5($_POST['code']) != $_SESSION['key']) 
    die("You've entered a wrong code!");
  $query = mysql_query("SELECT * FROM entities WHERE Name = '". $InGameName ."'"); 
  if (mysql_num_rows($query) < 0) 
  { 
     die("This In game name doesn't exist , please enter your account name not username!");
  }
  else
  {
    $date = date('YmdHis');
    $row=mysql_fetch_object($query);
    $lastvote=$row->LastVoteTime;
    $votingpoints = $row->VotsPoints;
    $url = "http://www.xtremetop100.com/in.php?site=***********";

    if(($lastvote + 120000) < $date)
    {
      $lastvote = $date;
      $votingpoints += 1;
      $query = mysql_query("update entities set VotsPoints ='$votingpoints' set LastVoteTime ='$lastvote' WHERE Name = '". $InGameName ."'"); 
    }
    else
      die("You've Already voted in the last 12 hrs!");
  }
}

?>

It does not update the database with the votingpoints and lastvotetime however it pass the first check (which means it found the account record in the database) but it doesn't set them in the end of that code thanks in advance

Upvotes: 1

Views: 408

Answers (2)

span
span

Reputation: 5624

Try:

$query = mysql_query("update entities set VotsPoints = '$votingpoints', LastVoteTime = '$lastvote' WHERE Name = '". $InGameName ."'");

You're using "set" multiple times, not sure if that's ok.

Upvotes: 2

Daniel Smith
Daniel Smith

Reputation: 1034

Your SQL syntax is incorrect on the UPDATE statement. http://dev.mysql.com/doc/refman/5.0/en/update.html

Upvotes: 0

Related Questions