【php开源代码栏目提醒】:以下是网学会员为您推荐的php开源代码-VoteResult.php,希望本篇文章对您学习有所帮助。
<HTML>
<HEAD><TITLE>投票区</TITLE></HEAD>
<BODY>
<CENTER>
<H2><FONT color=Blue>旅游地点票选</FONT></H2>
</CENTER>
<HR>
<?
//打开数据库
$db = mysql_connect("localhost","root");
mysql_select_db("vote");
//从vote数据表取得投票的编号和内容栏数据的SQL语句
$strSQL = "SELECT choice_no, content FROM vote;";
//执行SQL语句并打开记录集
$result = mysql_query($strSQL,$db);
?>
<TABLE bgcolor=LightYellow align=center>
<TR bgcolor=LightSkyBlue>
<TD><B>编号</B></TD><TD><B>地点</B></TD><TD><B>得票数</B></TD>
</TR>
<?
//利用while循环取出rstBook记录集中的数据,
while($record =
mysql_fetch_array($result))
{
$voteCount = "select * from result where choice ='".$record['choice_no']."';";
$coutResult = my
sql_query($voteCount,$db);
?>
<TR>
<TD>[<FONT color=Green><?echo $record['choice_no'] ?></FONT>]</TD>
<TD><B><FONT color=Brown><?echo $record['content'] ?>
</FONT></B></TD>
<TD align=right><FONT size = 5 color=Red>
<!--经过筛选的记录集其RecordCount属性即为票数-->
<?echo mysql_num_rows($coutResult)?></FONT>票</TD>
</TR>
<?
}
?>
</TABLE>
<?
mysql_close($db);
?>
</BODY>
</
HTML>