Voting script. need help (General)

by giorgi91, Tuesday, August 09, 2011, 18:27 (4662 days ago)

Hi, I'm making voting script

I want to vote for once per IP each question

<?
include "config.php";
$id = $_GET['id'];
$ip = $_SERVER['REMOTE_ADDR']; 
 
$ip_check = mysql_query("SELECT * FROM ip WHERE ip='$ip' and WHERE voteID='$id'",connect);
$do_ip_check = mysql_num_rows($ip_check);
 
if($do_ip_check > 0){
die("you already vote this question");
}
 
else {
echo "thanks for vote";
$sql = "update vs set xmebi1=xmebi1+1 where id='$id'";
} ?>


sql:

CREATE TABLE IF NOT EXISTS `ip` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `ip` VARCHAR(15) DEFAULT NULL,
  `voteID` INT(11) DEFAULT NULL,
  `name` text CHARACTER SET utf8,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
CREATE TABLE IF NOT EXISTS `vs` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `kitxva` VARCHAR(250) CHARACTER SET utf8 DEFAULT NULL,
  `text1` VARCHAR(100) CHARACTER SET utf8 DEFAULT NULL,
  `text2` VARCHAR(100) CHARACTER SET utf8 DEFAULT NULL,
  `main` INT(11) DEFAULT NULL,
  `cat` INT(11) DEFAULT NULL,
  `xmebi1` INT(11) DEFAULT NULL,
  `xmebi2` INT(11) DEFAULT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


in "vs" table plus one vote and
in "ip" table adding IP and question ID

sorry for my english. thanks.


Complete thread:

 RSS Feed of thread