Code: Select all
include_once("/var/www/html/php/db/logon.php");
mysql_connect($host, $user, $pass);
mysql_select_db("poll");
$qu = "SELECT * FROM votes";
$results = mysql_query($qu);
$i = 0;
$vote = $_REQUEST["proglan"];
if (isset($vote)) {
switch($vote) {
case "C++":
$cplus = mysql_result($results, $i, "cplus");
$newCplus = $cplus + 1;
$q = mysql_query("UPDATE votes SET cplus='$newCplus'");
break;
case "Java":
$java = mysql_result($results, $i, "java");
$newJava = $java + 1;
$q = mysql_query("UPDATE votes SET java='$newJava'");
break;
case "PHP":
$php = mysql_result($results, $i, "php");
$newPhp = $php + 1;
$q = mysql_query("UPDATE votes SET php='$newPhp'");
break;
default:
echo "How the hell?";
break;
}
}
$totalCplus = mysql_result($results, $i, "cplus");
$totalJava = mysql_result($results, $i, "java");
$totalPhp = mysql_result($results, $i, "php");
$foo = $totalCplus + $totalJava + $totalPhp;
$percCplus = $totalCplus / $foo * 100 * 2;
$percJava = $totalJava / $foo * 100 * 2;
$percPhp = $totalPhp / $foo * 100 * 2;
$percCplusOutput = $percCplus / 2;
$percJavaOutput = $percJava / 2;
$percPhpOutput = $percPhp / 2;I have suspicion it's where the mysql_query statements are placed.
Stephen,