Значит так. Голосование, при выборе варианта идет коннект к базе:
Код |
$dblocation = "тут хост"; $dbname = "тут база"; $dbuser = "имя.."; $dbpasswd = "...и соотв-но пароль"; $dbts = mysql_connect($dblocation, $dbuser, $dbpasswd) or die(mysql_error()); mysql_select_db($dbname); $dbch = mysql_query("SELECT * FROM `contest` WHERE `girl_id`='".$_POST['girl_id']."'"); $dbarr = mysql_fetch_assoc($dbch); $cur_count = $dbarr[vote_count]; $new_count = $cur_count + 1; mysql_query("UPDATE `contest` SET `vote_count` = '".$new_count."' WHERE `girl_id`='".$_POST['girl_id']."'"); mysql_free_result($dbch); mysql_close($dbts); |
Код |
$dblocation = "тут хост"; $dbname = "тут база"; $dbuser = "имя.."; $dbpasswd = "...и соотв-но пароль"; $dbts = mysql_connect($dblocation, $dbuser, $dbpasswd) or die(mysql_error()); mysql_select_db($dbname); $dbch = mysql_query("SELECT * FROM `contest` WHERE `girl_id`='".$_POST['girl_id']."'"); $dbarr = mysql_fetch_assoc($dbch); $cur_count = $dbarr[vote_count]; $new_count = $cur_count + 1; mysql_query("UPDATE `contest` SET `vote_count` = '".$new_count."' WHERE `girl_id`='".$_POST['girl_id']."'"); mysql_free_result($dbch); mysql_close($dbts); |