- 论坛徽章:
- 0
|
求助!一个调查统计原码
<?
$connection=@mysql_connect($hostname_config_inc,$username_config_inc,$password_config_inc);//or die("database error" ;
mysql_select_db($database_config_inc);
$query_r1 = mysql_query('SELECT * FROM resume order by id');
if ($radiobutton=="f1"
{
$num=mysql_result($query_r1,0,"num" ;
$num++;
$query="update resume set num=$num where id=1";
mysql_query($query);
}
if ($radiobutton=="y1"
{
$num1=mysql_result($query_r1,1,"num" ;
$num1++;
$query="update resume set num=$num1 where id=2";
mysql_query($query);
}
if ($radiobutton=="z1"
{
$num2=mysql_result($query_r1,2,"num" ;
$num2++;
$query="update resume set num=$num2 where id=3";
mysql_query($query);
}
?>;
<?
$connection=@mysql_connect($hostname_config_inc,$username_config_inc,$password_config_inc);//or die("database error" ;
mysql_select_db($database_config_inc);
$query_r1 = mysql_query('SELECT * FROM resume order by id');
$num1=mysql_result($query_r1,0,'num');
$num2=mysql_result($query_r1,1,'num');
$num3=mysql_result($query_r1,2,'num');
$numx=$num1+$num2+$num3;
$numm0=substr($num1/$numx*100,0,4)."%";
$numm1=substr($num2/$numx*100,0,4)."%";
$numm2=substr($num3/$numx*100,0,4)."%";
$poll_percentScale0 = (int)($numm0);
$poll_percentScale1 = (int)($numm1);
$poll_percentScale2 = (int)($numm2);
$strImage0="<img src='images/inc.gif' height=15 width=$poll_percentScale0>;";
$strImage1="<img src='images/inc.gif' height=15 width=$poll_percentScale1>;";
$strImage2="<img src='images/inc.gif' height=15 width=$poll_percentScale2>;";
//$strImage3="<img src='/images/inc.gif' height=18 width=$poll_percentScale3>;";
?>; |
|