Voting script. need help (General)
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.